SELECT CustState AS [State], COUNT(*) AS [Number of Customers]
FROM Customers
GROUP BY CustState

SELECT CustFirstName, CustLastName, COUNT(OrderNumber) AS [Number of Orders], MAX(OrderDate) AS [Lastest Date], MIN(OrderDate) AS [Earliest Date]
FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID
GROUP BY CustFirstName, CustLastName
ORDER BY 2;
