i am querying for the maximum occurance of a disease and also want to know which hospital had that recording but i get all the minimum recordings where there is a minimumu temperature.i am not getting the value for ‘name’
my code is like this:
sql1= “select name, min(cancer) as minimum from Hospital where disease=’cold’ group by name
