Francisco Cruz

Use HAVING clause with GROUP BY

Task 5

  • November 17, 2016 at 3:43 PM
  • Visible to public
SELECT name,Age FROM `Soccer_Players` group by Age having Age > 27

SELECT name, `Salary(Millions)` FROM `Soccer_Players` group by `Salary(Millions)` having `Salary(Millions)` > 20 and max(`Salary(Millions)`) < 100