Data Analysis, Data Analyst, Power Bi, Business Intelligence, Python.
returns the makers and model year with no.of distinct models concerning their year of model and makers --in descending orders. select make, model_year, count(distinct model) as no_of_models from dbo.Electric_Vehicle_Population_Dat$ group by model_year,make order by no_of_models desc, model_year