Mini-Project - Java Full Stack Developer - MySQL Hands-On Solutions | TCS Fresco Play | TCS | MNC Answers

0

Mini-Project - Java Fullstack Developer - MySQL Hands-On Solutions | TCS Fresco Play | TCS | MNC Answers

Disclaimer: The primary purpose of providing this solution is to assist and support anyone who are unable to complete these courses due to a technical issue or a lack of expertise. This website's information or data are solely for the purpose of knowledge and education.

Make an effort to understand these solutions and apply them to your Hands-On difficulties. (It is not advisable that copy and paste these solutions).

All Question of the MCQs Present Below for Ease Use Ctrl + F with the question name to find the Question. All the Best!


Mini-Project - Java Full Stack Developer - MySQL Hands-On Solutions

The Course Id is 63426.


/*

Enter your query below.

Please append a semicolon ";" at the end of the query

*/

select country.name, car_model.name, sum(sales.quantity*car_model.price) as total_sales from sales join country on country.id = sales.country_id join car_model on car_model.id = sales.model_id where sales.sales_date like "%2020" group by country.name, car_model.name order by total_sales asc;

 

*********************************


*****************************************
Credit for the above notes, goes to the respective owners. 

If you have any queries, please feel free to ask on the comment section.
If you want MCQs and Hands-On solutions for any courses, Please feel free to ask on the comment section too.

Please share and support our page!


Post a Comment

0Comments
Post a Comment (0)

Join Telegram Channel

Join MNCAnswers To Get Instant Updates

Join Telegram Channel