Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribed

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

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

Step: 3

blur-text-image

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

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2022 Grenoble France September 19 23 2022 Proceedings Part 4 Lnai 13716

Authors: Massih-Reza Amini ,Stephane Canu ,Asja Fischer ,Tias Guns ,Petra Kralj Novak ,Grigorios Tsoumakas

1st Edition

3031264118, 978-3031264115

More Books

Students also viewed these Databases questions