Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribedTAL 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 36. Display the Order Number, Total of items ordered, and the Total Price for each order for all orders with a Total Price greater than $350.00. 37. Display the Order Number, Total of items ordered, Total Price, Shipping and Grand Total for each order. Assume shipping charges are 5% of the total order. 38. Display the Order number, item number and number ordered for each order that includes item number FD11. 39. Display the Order Number and Order Date for all orders. 40. Display the Order Number and Order Date for all orders placed on or after 10/15/2015, 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 36. Display the Order Number, Total of items ordered, and the Total Price for each order for all orders with a Total Price greater than $350.00. 37. Display the Order Number, Total of items ordered, Total Price, Shipping and Grand Total for each order. Assume shipping charges are 5% of the total order. 38. Display the Order number, item number and number ordered for each order that includes item number FD11. 39. Display the Order Number and Order Date for all orders. 40. Display the Order Number and Order Date for all orders placed on or after 10/15/2015

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Management A Strategic Emphasis

Authors: Edward Blocher, David E. Stout, Gary Cokins, Kung Chen

4th Edition

0073128155, 978-0073128153

More Books

Students also viewed these Accounting questions