$/*[$Q$5]$ What is the most preferred vehicle make in each state?

Hint: Use the window function RANK$()$ to rank based on the count of customers for each state and vehicle maker.

After ranking, take the vehicle maker whose rank is $1.*/$

SELECT state, vehicle$\_$maker

FROM $($

SELECT state, vehicle$\_$maker, RANK$()$ OVER $($PARTITION BY state ORDER BY COUNT$(*)$ DESC$)$ AS rnk

FROM new$\_$wheels$\_$sales

GROUP BY state, vehicle$\_$maker

$)$ ranked

WHERE rnk $=1$;