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.

🧵
❓ 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.
Read 6 tweets
▶️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
🎯- Day 28 of #SQL Series 🤖

💹 Today I Solved a Two Amazing Questions 📙

🧵👇
🔗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 Image
Read 7 tweets
🎯- 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
Read 5 tweets
🎯- 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).
Read 8 tweets

Related hashtags

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.00/month or $30.00/year) and get exclusive features!

Become Premium

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

Donate via Paypal Become our Patreon

Thank you for your support!