Discover and read the best of Twitter Threads about #sqlquery
Most recents (5)
Are you a wine enthusiast? If you are, then you’ve probably heard of Wine Magazine.
🔥Let us solve one of the Advanced SQL interview questions on RANK function.
🧵
🔥Let us solve one of the Advanced SQL interview questions on RANK function.
🧵
❓ Question is taken from Wine Magazine that involves clauses like PARTITION BY, UNION ALL, CASE statements, and Window functions.
We will use a 3-step framework to solve the problem that can be used to solve any coding problem.
We will use a 3-step framework to solve the problem that can be used to solve any coding problem.
Find the cheapest and the most expensive variety in each region. Output the region along with the corresponding most expensive and the cheapest variety. Be aware that there are 2 region columns, the price from that row applies to both of them.
▶️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
🔗Q1) Problem Statement : Write a #Query to find no. of Gold Medal per swimmer for swimmer who won only Gold Medals .
#60daysofcodechallenge #60daysofSQL #30daysofSQL #sqlqueries #100daysofcodechallenge #SQLbySk #dataanalytics #business #sqlprogramming
#60daysofcodechallenge #60daysofSQL #30daysofSQL #sqlqueries #100daysofcodechallenge #SQLbySk #dataanalytics #business #sqlprogramming
🎯- Day 23 of SQL Series Project
🧵👇
🧵👇
🧠 SQL is the most important tool, a data analyst uses to manipulate and gain insights from the data. In this project, we will try to process, and analyze the data, for this purpose we will use this Zomato Datasets from Github
🎇 Github Link For DataSet & Code - lnkd.in/dw_zYAhK
#60daysofcodechallenge #60daysofSQL #30daysofSQL #sqlqueries #100daysofcodechallenge #SQLquery
#60daysofcodechallenge #60daysofSQL #30daysofSQL #sqlqueries #100daysofcodechallenge #SQLquery
🎯- Day 22 of SQL Series
🧵👇
🧵👇
❓Problem Statement : @UnitedHealthGrp has a program called Advocate4Me, which allows members to call an advocate and receive support for their #health care needs – whether that's behavioural, clinical, well-being, health care financing, benefits, claims or #pharmacy help.
- Calls to the Advocate4Me call centre are categorised, but sometimes they can't fit neatly into a category. These uncategorised calls are labelled “n/a”, or are just empty (when a support agent enters nothing into the category field).
