Discover and read the best of Twitter Threads about #sqlqueries
Most recents (7)
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
👨💻 10 different ways to remove duplicate records in SQL
🧵
🧵
1 - Delete using Unique Identifier.
2 - Using SELF join.
3 - Using Window function.
4 - Using MIN function. This delete even multiple duplicate records.
2 - Using SELF join.
3 - Using Window function.
4 - Using MIN function. This delete even multiple duplicate records.
5 - Using backup table.
6 - Using backup table without dropping the original table.
7 - Delete using CTID.
8 - By creating a temporary unique id column.
6 - Using backup table without dropping the original table.
7 - Delete using CTID.
8 - By creating a temporary unique id column.
🔗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).
Finally, the #GoldacreReview is published! (During Parliamentary Easter holidays, mid-ping-pong on the #HealthAndCareBill...)
It's 221 pages - each PDF page is a double page spread - so this could be a lo-o-o-ong [Thread].
Here goes...
It's 221 pages - each PDF page is a double page spread - so this could be a lo-o-o-ong [Thread].
Here goes...
First point to note, in the Terms of Reference (p5), is that this is about "access to #NHSdata by #researchers, #commissioners, and #innovators" - i.e. #Planning and #CommercialReUse - so it is directly relevant to the operation of millions of people's #NationalDataOptOuts...
"185 wide-ranging recommendations for us to explore", says @sajidjavid (p6). Gulp! Time for some coffee...
"systems that ensure #underrepresented groups are well represented" may (partly) refer to this "landmark review", which got off to a slow start:
gov.uk/government/new…
"systems that ensure #underrepresented groups are well represented" may (partly) refer to this "landmark review", which got off to a slow start:
gov.uk/government/new…
