Question: can you please tell me what I am doing wrong. I am confused. order by c.Last_Name: select TOP 5 products.PRODUCT_ID, products.PRODUCT_NAME, sum (order_lines. QUANTITY) AS

 can you please tell me what I am doing wrong. I

can you please tell me what I am doing wrong. I am confused.

am confused. order by c.Last_Name: select TOP 5 products.PRODUCT_ID, products.PRODUCT_NAME, sum (order_lines.

order by c.Last_Name: select TOP 5 products.PRODUCT_ID, products.PRODUCT_NAME, sum (order_lines. QUANTITY) AS Number_Ordered from products inner join order_lines on products. PRODUCT_ID = order_lines.PRODUCT_ID GROUP BY products.PRODUCT_ID ORDER BY Sum(order_lines. QUANTITY) DESC; select count (payment_description) from payment method where payment_description = 'CASH'; select shipment method_id, (Select shipment_description from shipment method where shipment method.shipment_method id = orders. shipment method_id) Lo Query Result + HE SQL Executing select TOP 5 products.PRODUCT_ID products.PRODUCT_NAME,sum(order_lines. QUANTITY) AS Number_Orderedfrom products inner join order_lines onproducts.PRODUCT_ID =order_lines.PRODUCT_IDGROUP BY products.PRODUCT_IDORDER BY Sum(order_lines. QUANTITY) DESC in 0s ORA-00923: FROM keyword not found where expected 00923. 00000 - FROM keyword not found where expected" *Cause: Action: Error at Line: 7 Column: 12 pts 2. Write a query to show best-selling products (IDs, product name, and Sold quantity). Show top five best-selling products. Sort by sold quantity in descending order. 5pts

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!