Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 am confused.
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
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