Question : Give a query that checks whether the minimum salary in each country is at least 40% of the maximum salary for that country.

so far I can get the max salaries of every country using this query.

select a.salary , a.country from agent a where a.salary = (select max(b.salary) from agent b where a.country = b.country) group by a.country, a.salary;

please continue the asnwer.

Thank you.