top of page

Given as follows are the schema details of sales for different car models.

 

The car_model table contains the details of car models sold and their prices.
The country table contains the country name and id of the cars being sold.
the sales table contains the sales record of the cars.
Write a query that calculates the country-wise sales for all the car models along with the total sales for the year 2020 in ascending order.

 

The output should be in the following format.
country_name          car_model         total_sales

HackerRank MySQL - Java Developer Solution

$15.00Price
  • You will get the complete query Solution in a PDF file with 100% accuracy to get 100% qualify the exam at your mail after buying the solution.
    For any query you can connect with us any time 24/7.

bottom of page