Practice Queries

Tasks

  1. Employee/Projects/Timecards DB: Find the project(s) with the most employees working on it (have submitted time cards)
  2. Employee/Projects/Timecards DB: Find the manager who has the lowest hourly wage of all managers. Print their full name and hourly wage. Solve this problem in different ways:
    1. Using MIN() aggregate function
    2. Without using aggregate functions and without using Universal Quantifier
    3. Using Universal Quantifier
    4. Using set operations only

Database Resources