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 $55000? 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, Sales_Reps
WHERE customer# = cust# and cust_salesrep = rep# and cost $55000;
SELECT order#, RepName, custName, Cost$
FROM orders, customers, Sales_Reps
WHERE customer# = cust# and cust_salesrep = rep# and cost $>55000;
SELECT order#, RepName, custName, Cost$
FROM orders, customers, Sales_Reps
WHERE customer# = cust# and cust_salesrep = rep# and cost $?'$55000';
SELECT order#, RepName, custName, Cost$
FROM orders, customers, Sales_Reps
WHERE customer# = cust# and cust_salesrep = rep# and cost $55000;
 Which SELECT statement will print all the orders over $55000? Include

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!