Answered step by step
Verified Expert Solution
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 $ and $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 PKFK pairs joinshint: you should have rows of output ordered properly
Product Table
PCODE PDESCRIPT PINDATE PQOH PMIN PPRICE PDISCOUNT VCODE
QER Power painter, psi., nozzle NOV
QP in pwr saw blade DEC
QLin pwr saw blade NOV
QQ Hrd cloth, inxJAN
QW Hrd cloth, inxJAN
QTY BD jigsaw, in blade DEC
QWE BD jigsaw, in blade DEC
QPD BD cordless drill, inJAN
HB Claw hammer JAN
AA Sledge hammer, lbJAN
T Rattail file, in fine DEC
WREQ Hicut chain saw, inFEB
PVCDRT PVC pipe, inft FEB
SMin metal screw, MAR
SWin wd screw, FEB
WRTT Steel, xx mesh JAN
Customer Table
CUSCODE CUSLNAME CUSFNAME CUSINITIAL CUSAREACODE CUSPHONE CUSBALANCE
Ramas Alfred A
Dunne Leona K
Smith Kathy W
Olowski Paul F
Orlando Myron
O'Brian Amy B
Brown James G
Williams George
Farriss Anne G
Smith Olivette K
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started