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
bottom of page