Well done! In business reports, we often want to calculate certain metrics for multiple business objects at the same time. For instance:

SELECT
  O.OrderID,
  COUNT(*) AS OrderItemsCount
FROM Orders O
JOIN OrderItems OI
  ON O.OrderID = OI.OrderID
WHERE O.OrderID BETWEEN 10200 AND 10300
GROUP BY O.OrderID;

In the query above, we count the number of items in each order with an OrderID in the specified range. By joining the Orders and OrderItems tables, we can display information about a single order item and its parent order on the same row. Then, we group all rows by their parent order and use COUNT(*) to find the number of items in each order.