TAL Distributor database

334 665 Rep RepNum LastName FirstName Street City State PostalCode Commission Rate 15 Campos Rafad 724 Vinca Dr. Grove CA 90092 $23,457.50 0.06 30 Gradey Megan 632 Liatris St. Fullton CA 90085 $41,317.00 0.08 45 Tun Hu 1785 Tyler Ave. Northfield CA 90098 $27,789.25 0.06 60 Sefton Janet 267 Oakley St. Congarce CA 90097 $0.00 0.06 Customer CustomerNum CustomerName Street City State PostalCode Balance CreditLimit RepNum 126 Toys Galore 28 Laketon St. Fullton CA 90085 $1,210.25 $7,500.00 15 200 Brookings Direct 452 Columbus Dr. Grove CA 90092 $575.00 $10,000.00 30 The Everything 342 Magee St. Congaree CA 90097 $2,345.75 $7,500.00 45 Shop Johnson's 124 Main St Northfield CA 90098 $879.25 $7,500.00 30 Department Store Grove 3456 Central Ave. Fullton CA 90085 $345.00 $5,000.00 45 Historical Museum Store Cards and More 167 Hale St. Mesa CA 90104 $5,025.75 $5,000.00 15 Almondton 586 3345 Devon Ave. Almondton CA 90125 $3,456.75 $15,000.00 45 General Store Cricket Gift Shop 372 Osdord St. Grove CA 90092 $678.90 $7,500.00 30 713 Cross Store 12 Rising Sun Ave. Congarce CA 90007 $4,234.60 $10,000.00 15 796 Unique Gifts 786 Passmore St. Northfield CA 90098 $124.75 $7,500.00 45 824 Kline's 945 Gilham St. Mesa CA 90104 $2,475.99 $15,000.00 30 All Season Gifts 382 Wildhood Ave. Fullton CA 90085 $935.75 $7,500.00 15 Orders OrderLine Order Num Order Date CustomerNum Order Num ItemNum NumOrdered QuotedPrice 51608 10/12/2015 126 51608 CD33 $86.99 51610 10/12/2015 334 51610 KL78 $10.95 51613 10/13/2015 386 51610 TR40 $13.99 51614 10/13/2015 260 51613 DL51 $104.95 51617 10/15/2015 586 51614 FD11 $124.95 51619 10/15/2015 126 51617 NL89 $115.99 51623 10/15/2015 586 51617 TW35 $116.95 51625 10/10/2015 796 51619 FD11 $121.95 51623 DR67 $29.95 51623 FH24 $36.95 51623 KD 34 $13.10 51625 MT03 $45.79 Item ItemNum Description OnHand Category Storehouse Price AH74 Patience 9 GNE $22.99 BR23 Skittles 21 GME : $29.99 CD33 Wood Block Set (48 piece) 36 TOY 1 $89.49 DISI Classic Railway Set 12 TOY 3 $107.95 DR67 Giant Star Brain Teaser 24 PZL $31.95 DW23 Mancala 40 GME $50.00 FD11 Rocking Horse 8 TOY $124.95 FH24 Puzde Gift Set 65 PZL $38.95 KA12 Cribbage Set 56 GME $75.00 KD34 Pentominoes Brain Teaser 60 PZL 2 $14.95 KL78 Pick Up Sticks | 110 GME 1 $10.95 MT03 Zauberkasten Brain Teaser 45 PZL 1 $45.79 NL89 Wood Block Set (62 piece) 32 TOY 3 $119.75 TR40 Tic Tac Toe 75 GME 2 $13.99 TW35 Fire Engine 30 TOY 2 $118.95 26. Display item number, item name, category and price for all items that are not toys. 27. Display item number, item name, and amount on hand for the items that have less than 20 on hand. Ordere data by the on hand value. 28. Display the total on hand value for each category in the Item table. Order the results by category 29. Display item number, item name, and amount on hand for the items that have less than 20 on and on storehouse 2. 30. Display item number, item name, and amount on hand for the items that have less than 5 on hand. 334 665 Rep RepNum LastName FirstName Street City State PostalCode Commission Rate 15 Campos Rafad 724 Vinca Dr. Grove CA 90092 $23,457.50 0.06 30 Gradey Megan 632 Liatris St. Fullton CA 90085 $41,317.00 0.08 45 Tun Hu 1785 Tyler Ave. Northfield CA 90098 $27,789.25 0.06 60 Sefton Janet 267 Oakley St. Congarce CA 90097 $0.00 0.06 Customer CustomerNum CustomerName Street City State PostalCode Balance CreditLimit RepNum 126 Toys Galore 28 Laketon St. Fullton CA 90085 $1,210.25 $7,500.00 15 200 Brookings Direct 452 Columbus Dr. Grove CA 90092 $575.00 $10,000.00 30 The Everything 342 Magee St. Congaree CA 90097 $2,345.75 $7,500.00 45 Shop Johnson's 124 Main St Northfield CA 90098 $879.25 $7,500.00 30 Department Store Grove 3456 Central Ave. Fullton CA 90085 $345.00 $5,000.00 45 Historical Museum Store Cards and More 167 Hale St. Mesa CA 90104 $5,025.75 $5,000.00 15 Almondton 586 3345 Devon Ave. Almondton CA 90125 $3,456.75 $15,000.00 45 General Store Cricket Gift Shop 372 Osdord St. Grove CA 90092 $678.90 $7,500.00 30 713 Cross Store 12 Rising Sun Ave. Congarce CA 90007 $4,234.60 $10,000.00 15 796 Unique Gifts 786 Passmore St. Northfield CA 90098 $124.75 $7,500.00 45 824 Kline's 945 Gilham St. Mesa CA 90104 $2,475.99 $15,000.00 30 All Season Gifts 382 Wildhood Ave. Fullton CA 90085 $935.75 $7,500.00 15 Orders OrderLine Order Num Order Date CustomerNum Order Num ItemNum NumOrdered QuotedPrice 51608 10/12/2015 126 51608 CD33 $86.99 51610 10/12/2015 334 51610 KL78 $10.95 51613 10/13/2015 386 51610 TR40 $13.99 51614 10/13/2015 260 51613 DL51 $104.95 51617 10/15/2015 586 51614 FD11 $124.95 51619 10/15/2015 126 51617 NL89 $115.99 51623 10/15/2015 586 51617 TW35 $116.95 51625 10/10/2015 796 51619 FD11 $121.95 51623 DR67 $29.95 51623 FH24 $36.95 51623 KD 34 $13.10 51625 MT03 $45.79 Item ItemNum Description OnHand Category Storehouse Price AH74 Patience 9 GNE $22.99 BR23 Skittles 21 GME : $29.99 CD33 Wood Block Set (48 piece) 36 TOY 1 $89.49 DISI Classic Railway Set 12 TOY 3 $107.95 DR67 Giant Star Brain Teaser 24 PZL $31.95 DW23 Mancala 40 GME $50.00 FD11 Rocking Horse 8 TOY $124.95 FH24 Puzde Gift Set 65 PZL $38.95 KA12 Cribbage Set 56 GME $75.00 KD34 Pentominoes Brain Teaser 60 PZL 2 $14.95 KL78 Pick Up Sticks | 110 GME 1 $10.95 MT03 Zauberkasten Brain Teaser 45 PZL 1 $45.79 NL89 Wood Block Set (62 piece) 32 TOY 3 $119.75 TR40 Tic Tac Toe 75 GME 2 $13.99 TW35 Fire Engine 30 TOY 2 $118.95 26. Display item number, item name, category and price for all items that are not toys. 27. Display item number, item name, and amount on hand for the items that have less than 20 on hand. Ordere data by the on hand value. 28. Display the total on hand value for each category in the Item table. Order the results by category 29. Display item number, item name, and amount on hand for the items that have less than 20 on and on storehouse 2. 30. Display item number, item name, and amount on hand for the items that have less than 5 on hand