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.

🧵
❓ 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.
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.
The goal of the problem is to display the most expensive and cheapest wine for each region mentioned in the dataset. Speaking of the dataset, let us take a peek at the dataset itself. @StrataScratch

stratascratch.com/blog/wine-maga…

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Sachin Kumar

Sachin Kumar Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @Sachintukumar

Mar 12
Top 25 SQL Interview Questions and Answers

🧵
There are certain SQL concepts which you should be familiar with if you plan to attend an #SQL interview. No matter which RDBMS you use wether it is MySQL, Oracle, Microsoft SQL Server, #PostgreSQL or any other, these SQL concepts are common for all of the popular RDBMS.
Read 5 tweets
Mar 10
How should you 𝐥𝐞𝐚𝐫𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈? 🚀

🧵
It's easy to be overwhelmed by how broad #PowerBI is😖

If you're starting out, here's the path I recommend⏬
📊 𝐃𝐚𝐭𝐚 𝐌𝐨𝐝𝐞𝐥𝐢𝐧𝐠
Begin by learning to organize data into tables, create relationships, and add calculated columns and measures.

This is the most important part of your journey, as understanding the #data is always the first step in Power BI development.
Read 13 tweets
Mar 10
▶️Practice Writing SQL Queries using Real
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
Read 9 tweets
Mar 8
👨‍💻 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.
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.
Read 4 tweets
Mar 6
6 Must have line charts for business data analysis 📈👌 💯

🧵
1. Indexed chart for comparing trend
2. #Sparkline for tiny insight
3. Spaghetti line #chart for bringing focus
4. Smoothed line chart for evening out edge
5. Forecast chart to predict future value based on trend & seasonality
6. Line chart combination when just a line won't do
▶ Line charts are similar to #scatterplots except that they connect the data points with lines. Choose a line chart when ordering and joining the #data points by their X-axis values highlights meaningful changes in the vertical Y-axis variable.
Read 4 tweets
Feb 19
🚀 You can become a data analyst in 90 days without spending a cent! Yes, you heard that right.

With the right approach and dedication, anyone can become a #dataanalyst . Here are the steps to follow( Make sure the order is maintained)

🧵
Learn Excel - Time : 12 days
🎙️ Tutorials -
lnkd.in/eWmC2vf8
🏗️ Projects -
lnkd.in/ew5y5KP7
Learn Basic Statistics - Time : 3 days
🎙️ Tutorials -
lnkd.in/emKawHBs
Read 10 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us on Twitter!

:(