kaamilp

Untitled

Mar 25th, 2020
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.20 KB | None | 0 0
  1. SELECT t.TEAM_NAME
  2. FROM teams t
  3. JOIN employees emp on t.TEAM_ID = emp.TEAM_ID
  4. GROUP BY t.TEAM_NAME
  5. HAVING MIN(emp.DATE_OF_BIRTH) >(SELECT e.DATE_OF_BIRTH
  6. FROM employees emp WHERE EMP_NAME = 'FRESH');
Advertisement
Add Comment
Please, Sign In to add comment