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.