SQL Data Analyst Project: Car Sales Data

If you want to improve your SQL, you'll need to practice your skills.

A great way to do this is to download a sample data set and run some SQL on it.

In this video, you will learn how to:
- download a sample CSV data set on car sales
- import this CSV into a database
- answer a range of questions we have about the data

⏱ TIMESTAMPS:
00:00 - Setting up our data
05:39 - Q1 sales in each state
11:09 - Q2 make and model
12:57 - Q3 avg state prices
13:31 - Q4 avg prices per month
19:03 - Q5 num sales each month
21:40 - Q6 top models for each body type
25:09 - Q7 sales higher than model average
27:51 - Q8 condition and sales price
29:31 - Q9 odometer and sales price
30:32 - Q10 brand details
32:02 - Q11 cars sold multiple times

🔗 VIDEO LINKS:

Import a CSV in different editors:

[osoriomatucurane]

Awesome crystal clear tutorial. Prove me if I am wrong, it is the best SQL case study tutorial on youtube, by all standards. Being a person who enjoy programmatic data cleaning, I really love the dynamic and interactive approach in whole analysis. Now, is there anything that could be missing in a typically SQL data analytics Sales project? Not sure, it could be the market share analysis of the top 10 brands or the states

[Seasmoke_]

Sir table data import is taking too much time ?

[aodinaz]

import failed. receiving "row import failed with error: "incorrect integer value: " for column 'condition at row 1", 1366. This is the date column. I can see workbench is typing this as an integer field. However; I can import into Excel and the date column is formatted correctly. I resave as a csv from my Excel but it still fails in workbench. even when the column is unchecked for loading it still fails.