▶️Practice Writing SQL Queries using Real
Dataset 💯
🧵
Dataset 💯
🧵
“The very first thing, we must do when writing #SQL queries, is to understand the underlying data. Once we understand the data and how this data is stored across different tables, it becomes much simpler to write SQL #Queries to retrieve any information from that data”
✅List of SQL Queries:
We shall write SQL #Queries using this data. For each of these queries, you would find the problem statement and then the screen shot of the expected output. Under each of these 20 problem statement
We shall write SQL #Queries using this data. For each of these queries, you would find the problem statement and then the screen shot of the expected output. Under each of these 20 problem statement
1- How many olympics games have been held?
2- List down all #Olympics games held so far.
3- Mention the total no of nations who participated in each olympics game?
4- Which year saw the highest and lowest no of countries participating in olympics?
2- List down all #Olympics games held so far.
3- Mention the total no of nations who participated in each olympics game?
4- Which year saw the highest and lowest no of countries participating in olympics?
5- Which nation has participated in all of the olympic games?
6- Identify the sport which was played in all summer olympics.
7- Which Sports were just played only once in the olympics?
8- Fetch the total no of sports played in each olympic games.
6- Identify the sport which was played in all summer olympics.
7- Which Sports were just played only once in the olympics?
8- Fetch the total no of sports played in each olympic games.
9- Fetch details of the oldest athletes to win a gold medal.
10- Find the Ratio of male and female athletes participated in all olympic games.
10- Find the Ratio of male and female athletes participated in all olympic games.
✅Follow @Sachintukumar For More
#sqlprogramming #sqlqueries #sqldatabase #sqldeveloper #datascience #dataanalytics #dataanalystjobs #sqlquery #programming #dataviz #dataengineering #SQLTips #MachineLearning #Deeplearning #TechTwitter #Technology
#sqlprogramming #sqlqueries #sqldatabase #sqldeveloper #datascience #dataanalytics #dataanalystjobs #sqlquery #programming #dataviz #dataengineering #SQLTips #MachineLearning #Deeplearning #TechTwitter #Technology
• • •
Missing some Tweet in this thread? You can try to
force a refresh
