SQL for data Analysis | Customer Analysis with practical examples | SQL CTE and Subquery

Показать описание

SQL tutorial for beginners - Learn SQL, the world's widely used language for data analysis and manipulation.

Focus in this video:
1. Derive a new vs returning customer flag. Find out how many customers have repeat purchase vs single purchase?
2. What is our customer repeat rate?
3. On average, how many orders do we receive per day?
4. What's our average daily sales?

If you're looking for a SQL tutorial for beginners with practical examples, then this tutorial is a great way to learn SQL basics. Just follow through and you'll be able to write SQL queries in no time.

SQL stands for Structured Query Language. It is used by data analyst, data scientists, database administrators and anyone who works with data. With SQL, you can store data in relational databases and write queries to extract data from a database.

Subscribe to our channel:

---------------------------------------------
Follow me on social media!

---------------------------------------------

#SQL #CTE #Subquery

Topics covered in this video:
0:00 - Intro to topics
1:27 - Common Table Expression (CTE)
2:23 - Subquery
3:09 - Repeat vs New Customers
6:08 - Customer Repeat Rate
5:51 - SQL INNER JOIN
8:21 - Daily Averages Sales & Order Count