select c.FirstName, c.LastName, count(orderid) as Orders
from Customers c join Orders o on c.CustomerID = o.CustomerID
group by c.FirstName, c.LastName