Data Analysis, Data Analyst, Power Bi, Business Intelligence, Python.
dbo.Electric_Vehicle_Population_Dat$ where make='Volvo' --find distinct no.of models made by different makers in different cities and find no.of records from this. with cte as ( select city,make, count(distinct model) as no_of_models from dbo.Electric_Vehicle_Population_Dat$ group by city,make)