SQLQuestion:

What is the value of orders placed for each item? Report all items, and indicate zero if no orders are placed.

Based on these tables:

REP REP NUM LAST NAME FIRST NAME STREET CITY STATE POSTAL CODE COMMISSION RATE 30 45 632 Liatris St Fullton 1785 Tyler Ave. Northfield CA 0085 90098 41.317.00 $27,789.25 | 0.06 SeftonJanet 267 Oakley St. Congaree CA 97 $0.00 0.06 CUSTOMER CUSTOMER NUM CUSTOMER NAME STREET 126 CITY Toys Galore Brookings Direct 452 Columbus Dr. Grove STATE POSTAL CODE BALANCE CREDIT LIMIT REP NUM CA CA 90092 28 Laketon St. Fullton 90085 $7,500,00 15 $575,00$10,000.00 30 $2,345.75 $7.500.00 45 $1.210,25 334 The Everything 342 Magee St. Congaree CA 90097 Shop Johnsons Department Store Grove Historical Muscum Store Cards and More 167 Hale St 386 124 Main St Northheld CA 90098 $879.25$7,500.00 30 440 3456 Central Ave. Fullton CA 90085 $345,00 $5,000,00 45 $5,025.75 $5,000.00 15 $3.456,75 $15,000,00 45 $678.90$7,500.00 30 $4,234.60 $10,000.00 15 $124.757.500.00 45 $2,475,99 $15,000,00 30 $935.75 $7,500.00 15 Mesa GA 0104 mondton General Store 3345 Devon Ave. Almondton CA 90125 586 CA 90092 90097 90098 90104 Cricket Gife Shop 372 Oxford St. Cress Store .Grove 713 790 824 893 12 Rising Sun ve. Congaree CA 786 Passmore St. Northfield CA 945 Gilham St Unique Gifts Mesa CA All Season Gifts 382 Wildwood Ave. Fullton ORDER LINE ORDER NUM ORDER DATE CUSTOMER NUMORDER NUM ITEM NUM NUM ORDERED QUOTED PRICE 51608 51610 51613 51614 51617 51608 51610 10012/2015 126 10/12/2015 334 1012015 386 10/13/2015 260 V15/2015 586 10/15/2015 126 10/15/2015 586 106/2015 796 51613 51614 51617 51617 51619 51623 51623 51623 51625 KL78 TR40 DL51 FD11 NLS9 TW35 $13.99 $104.95 $124.95 $115,99 $116.95 $121.95 $29.95 $36.95 $13.10 $45.7 51623 51625 3 DR67 FH24 MTO3 ITEM ITEM NUM DESCRIPTION ON HAND CATEGORY STOREHOUSE PRICE 9 ME 21 GME 36 TOY 2 TOY 24 PZL 40 GME 8 | Patience 3 BR23 CD33 DL51 DR67 DW23 FD11 PH24 KA12 KD34 KL78 MTO3 Wood Block Set (48 piece) Classic Railway Set Giant Star Brain Teaser Mancala Rocking Horse Puzzle Gift Set Cribbage Set Pentominoes Brain Teaser Pick Up Sticks Zauberkasten Brain Teaser Wood Block Set (62 piece) Tic Tae Toe Fire Engine $89.49 $107.95 $31.95 $50.00 $124.9 56 GME 60 PZL 110 GME 45 PZL 32 TOY 75 GME 30 | $38.95 $75.00 $14.95 $10.9 $45.79 $119.75 $13 TW35 $118.95