ADVANCED SQL:

List the customer first name and last name and the number of orders (name the column NumberOfOrders). List all customers even if they have never placed an order. Order the output by number of orders.

Customer CustomerID FirstName Saleltem SaleID ProductID Product ProductID Manufacturer ManufacturerID - ProductName Sale SaleID SaleDate Customer D Tax Shipping LastName Item Size Quantity StreetAddress City ManufacturerID Composition ListPrice Sale Price ManufacturerName Address1 Address2 City State PostalCode Phone State Gender Employee PostalCode Country Category Color Employeeld Phone FirstName Fax Description Contact LastName Address City State Salary Employee Employeeld - Salary URL ZIP Phone WageEmployee Employeeld on Wage Manager D SSN EmailAddress HireDate MaxHours