Use SI database and answer following queries;$-$

Use Analytical function approach to display the details of car with highest list price in each make.

Write Query using Analytical function to display name of customer who bought the most expensive car among all customers.

Write Query to print number of cars in each carmake and caryear, which are still left to be sold. Make sure to display subtotal for every possible combinations of carMake and carYear as well as overall subtotal using Advanced grouping criteria. $[$Simple group by query will result in $0$ grades make sure to use advanced grouping criteria posted in Week$-10$ content$]$