Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing Fundamentals Design

Authors: Marion Donnie Dutton Don F. Seaman

14th Edition Globel Edition

1292107634, 978-1292107639

More Books

Students also viewed these Databases questions