Master SQL with Car Sales Data Analysis 🚗: Step-by-Step Project Guide

Get this Data Analysis Project Guide: https://databasestar.mykajabi.com/lpkj-data-analysis-projects/?video=xlSWkDZkAO4
🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql-simplified/?video=xlSWkDZkAO4

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:
Car sales data set on Kaggle: https://www.kaggle.com/datasets/syedanwarafridi/vehicle-sales-data

Import a CSV in different editors:
DBeaver: https://www.youtube.com/watch?v=u2N4UEL8Lm8
MySQL Workbench: https://www.youtube.com/watch?v=sfRwJH04QJc
SQL Developer: https://www.youtube.com/watch?v=GcB4_0Iz2Zw