Scribd
Upload
230 views1 page

Mini Project: Java Sales Analysis

This document provides a link to join a Telegram channel and a SQL query to run in the console to select the country name, car model name, and total sales amount for 2020 from sales, country, and car model tables by joining on country and model IDs and grouping the results.

Uploaded by

mohamed yasin
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
230 views1 page

Mini Project: Java Sales Analysis

This document provides a link to join a Telegram channel and a SQL query to run in the console to select the country name, car model name, and total sales amount for 2020 from sales, country, and car model tables by joining on country and model IDs and grouping the results.

Uploaded by

mohamed yasin
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Join our channel if you haven’t joined yet [Link]

me/fresco_milestone ( @fresco_milestone )

Copy paste below query in the console then runtest

select [Link], [Link], sum([Link] * [Link]) as total_sales from sales as a,country as


b,car_model as c where a.country_id=[Link] and a.model_id=[Link] and a.sales_date like "%2020" group
by [Link],[Link];

You might also like