im working on this data set :
Novel Corona Virus 2019 Dataset | Kaggle
and what i want is : The total number of confirmed cases per province or, when not
available, by country .
Can you help me ?
i tried this , but isnt right because in this case i cant do the SUM
Select SUM (Confirmed),Province_State,Country_Region
Group by Province_State,Country_Region