How to find hospital name who got most registered cancer disease in each City

Question

i have table which is having City , hospital name, disease....How to find hospital name who got most cancer disease in each City... thanks in advance

Answer 1

SELECT hospital_name AND city FROM table WHERE cancer>=maximum_registered;