Francisco Cruz

Use aggregate functions in query

Task 4

  • November 17, 2016 at 3:43 PM
  • Visible to public
SELECT min(`Salary(Millions)`), max(`Salary(Millions)`) FROM `Soccer_Players`

SELECT max(age), min(age)  FROM `Soccer_Players`

SELECT sum(age), sum(`Net Worth(Millions)`) FROM `Soccer_Players`

SELECT age, Count(*) FROM `Soccer_Players` group by `Age`