Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Here's what I have so far as an SQL Query: SELECT CUSTOMERS.CustID, CUSTOMERS.Cname, COUNT(DISTINCT ORDERS.OrderID) AS 'Nbr of Orders' FROM CUSTOMERS LEFT JOIN ORDERS ON
Here's what I have so far as an SQL Query:
SELECT CUSTOMERS.CustID,
CUSTOMERS.Cname,
COUNT(DISTINCT ORDERS.OrderID) AS 'Nbr of Orders'
FROM CUSTOMERS LEFT JOIN ORDERS ON CUSTOMERS.CustID = ORDERS.CustID
GROUP BY CUSTOMERS.CustID, CUSTOMERS.Cname
ORDER BY 'Nbr of Orders' DESC
It gives me a list of 'Nbr of Orders' in decending order, but I want only the top ranking item to appear. How do I do that? I need this as soon as possible. It is due soon.
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