Sql assignment-2 doubt

#1

I am not able to solve question-9 from SQL cars assignment. Please guide how to solve this problem.

#2

@Pusto first used group by with year and model to sum the total income, and then max to find the maximum value from each group by year

#3

It is not working .i am writing the following query:-
select name,year, max(total_made) from cars group by year;

#4

@Pusto try following query,
select name, year, max(total_made) from (select sum(total_made), name, year from cars group by year, name) group by year;

#5

I hope I’ve cleared your doubt. I ask you to please rate your experience here
Your feedback is very important. It helps us improve our platform and hence provide you
the learning experience you deserve.

On the off chance, you still have some questions or not find the answers satisfactory, you may reopen
the doubt.