Question: write a create table and insert the table below Items_Ordered table begin{tabular}{|l|l|l|l|l|l|l|} hline multicolumn{1}{|c|}{ ID } & customerid & multicolumn{1}{|c|}{ item } & multicolumn{1}{|c|}{ quantity
Items_Ordered table \begin{tabular}{|l|l|l|l|l|l|l|} \hline \multicolumn{1}{|c|}{ ID } & customerid & \multicolumn{1}{|c|}{ item } & \multicolumn{1}{|c|}{ quantity } & \multicolumn{1}{|c|}{ price } \\ \hline 1 & 10101 & 30-Jun-1999 & Raft & 1 & 58.00 \\ \hline 2 & 10339 & 27-Jul-1999 & Umbrella & 1 & 4.50 \\ \hline 3 & 10449 & 14 Aug-1999 & Ski Poles & 2 & 25.50 \\ \hline 4 & 10415 & 18 Dec-1999 & Tent & 1 & 88.00 \\ \hline 5 & 10438 & 02-Dec-1999 & Pillow & 1 & 8.50 \\ \hline 6 & 10449 & 22-Dec-1999 & Canoe & 1 & 280.00 \\ \hline 7 & 10101 & 02-Jan-2000 & Lantern & 1 & 16.00 \\ \hline 8 & 10438 & 18-Jan-2000 & Tent & 1 & 79.99 \\ \hline 9 & 10409 & 29-Feb-2000 & Flashlight & 1 & 4.50 \\ \hline 10 & 10101 & 08-Mar-2000 & Sleeping Bag & 2 & 88.70 \\ \hline 11 & 10298 & 01-Apr-2000 & Ear Muffs & 1 & 12.50 \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
