Question: Which SELECT statement will print all the orders over $ 5 5 0 0 0 ? Include the order number, the name of the salesperson,
Which SELECT statement will print all the orders over $ Include the order number, the name of the salesperson, the name of the customer and the cost of the order.
SELECT order# RepName, custName, Cost$
FROM orders, customers, SalesReps
WHERE customer# cust# and custsalesrep rep# and cost $;
SELECT order# RepName, custName, Cost$
FROM orders, customers, SalesReps
WHERE customer# cust# and custsalesrep rep# and cost $;
SELECT order# RepName, custName, Cost$
FROM orders, customers, SalesReps
WHERE customer# cust# and custsalesrep rep# and cost $$;
SELECT order# RepName, custName, Cost$
FROM orders, customers, SalesReps
WHERE customer# cust# and custsalesrep rep# and cost $;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
