[Solved]Ed 700 S Wrong Sql Code Select Customername Sum Quantityordered Totalq Customers C Orders Q37226977

Asked what is wrong with the following SQLcode:

ed 7.00 on What’s wrong with this SQL code? select customername, sum(quantityordered) as totalq from customers c, orders, o, orderdetails d where c.customernumber o.customernumber group by customername having totalq < 400; Select one a. Nothing. This code will work fine. b. customername must be qualified by the alias “c O c. The join is not fully qualified, and requires another where clause d The alas totalr canot be used in the having clause Next page Show transcribed image text ed 7.00 on What’s wrong with this SQL code? select customername, sum(quantityordered) as totalq from customers c, orders, o, orderdetails d where c.customernumber o.customernumber group by customername having totalq

Expert Answer

---

Answer to ed 7.00 on What’s wrong with this SQL code? select customername, sum(quantityordered) as totalq from customers c, orders… . . .