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
Francisco Cruz
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