On the sample dataset db_employees:

  1. Compute the number of employees hired in each year
  2. Find the manager (that is, employee that do not report to any other person), who have been hired the longest time.
  3. Find the orders with the longest time between the submission and the approval.
  4. Find the order that has the most items
  5. Compute how the current number of units in stock is distributed among all categories
  6. Find the categories with the largest number of items in stock.