Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Display the product description, the full customer name and the customer balance for products ordered by customers having a customer balance between $ 2 0

Display the product description, the full customer name and the customer balance for products ordered by customers having a customer balance between $200.00 and $400(inclusive). Order by product description, customer last name. Look at the table layouts above and determine which tables to include here. You will need to use multiple tables and join them appropriately in the WHERE clause using PK/FK pairs (3 joins).[hint: you should have 4 rows of output ordered properly].
Product Table
P_CODE P_DESCRIPT P_INDATE P_QOH P_MIN P_PRICE P_DISCOUNT V_CODE
11QER/31 Power painter, 15 psi., 3-nozzle 03-NOV-202185109.99025595
13-Q2/P27.25 in. pwr. saw blade 13-DEC-2021321514.99.0521344
14-Q1/L39.00-in. pwr. saw blade 13-NOV-2021181217.49021344
1546-QQ2 Hrd. cloth, 14-in.,2x5015-JAN-202215839.95023119
1558-QW1 Hrd. cloth, 12-in.,3x5015-JAN-202223543.99023119
2232/QTY BD jigsaw, 12-in. blade 30-DEC-202185109.92.0524288
2232/QWE BD jigsaw, 8-in. blade 24-DEC-20216599.87.0524288
2238/QPD BD cordless drill, 12-in.20-JAN-202212538.95.0525595
23109-HB Claw hammer 20-JAN-202223109.95.121225
23114-AA Sledge hammer, 12 lb.02-JAN-20228514.4.05-
54778-2T Rat-tail file, 18-in. fine 15-DEC-202143204.99021344
89-WRE-Q Hicut chain saw, 16 in.07-FEB-2022115256.99.0524288
PVC23DRT PVC pipe, 3.5-in.,8-ft 20-FEB-2022188755.870-
SM-182771.25-in. metal screw, 2501-MAR-2022172756.99021225
SW-231162.5-in. wd. screw, 5024-FEB-20222371008.45021231
WR3/TT3 Steel, 4x8x16,.5 mesh 17-JAN-2022185119.95.125595
Customer Table
CUS_CODE CUS_LNAME CUS_FNAME CUS_INITIAL CUS_AREACODE CUS_PHONE CUS_BALANCE
10010 Ramas Alfred A 615844-25730
10011 Dunne Leona K 713894-12380
10012 Smith Kathy W 615894-2285345.86
10013 Olowski Paul F 615894-2180536.75
10014 Orlando Myron -615222-16720
10015 O'Brian Amy B 713442-33810
10016 Brown James G 615297-1228221.19
10017 Williams George -615290-2556768.93
10018 Farriss Anne G 713382-7185216.55
10019 Smith Olivette K 615297-38090
image text in transcribed

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

Murach's SQL Server 2012 For Developers

Authors: Bryan Syverson, Joel Murach, Mike Murach

1st Edition

1890774693, 9781890774691

More Books

Students also viewed these Databases questions

Question

=+b) Is MediaChips manufacturing process in control?

Answered: 1 week ago

Question

Explain the development of human resource management (HRM)

Answered: 1 week ago