Discover and read the best of Twitter Threads about #60daysofSQL

Most recents (11)

🎯- 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
🎯Day -17 on SQL Questions Series📓

▶️Today I Solved the #Olympic Gold Medal
Problem

🧵👇
Q17 ) In problem where we need to find player with no of gold medals won by them only for players who won only gold medals.?
📓Code Snippets :
Read 4 tweets
Day -16 on #Leetcode SQL Questions Series

🎯Today I Take a Question From
@LeetCode Platform 🔥

🧵👇
Q16 ) Write an SQL query to report all customers who never order anything.

Return the result table in any order.
🙌Thankyou @LeetCode for Providing such a great SQL Questions

📓Code Snippets : Image
Read 4 tweets
Day -15 on #Leetcode SQL Questions Series

🎯Today I Take a Question From @LeetCode Platform 🔥

🧵👇
Q15) A company's executives are interested in seeing who earns the most money in each of the company's departments. A high earner in a department is an employee who has a salary in the top three unique salaries for that department.
--- Write an SQL query to find the employees who are high earners in each of the departments.
Read 5 tweets
Day -12 on #JPMorgan SQL Questions Series

🧵👇
Q12) Write a query that outputs the name of each credit card and the difference in issued amount between the month with the most cards issued, and the least cards issued. Order the results according to the biggest difference.
🫡Thankyou Shri @NickSinghTechSir For Creating Such a Great Platform
@DataLemurHQ For SQL & Data Science Learners

🖍️Code Snippet :
Read 4 tweets
Day -11 on #TikTok SQL Questions Series

🧵👇
Q11) New TikTok users sign up with their emails & each user receives a text confirm to activate their Acc. Assume you r given below tables about email & text

Write query to display the id of the users who didn't confirm on the first day of sign-up but confirmed on the second day
🫡Thankyou Shri @NickSinghTechSir For Creating Such a Great Platform @DataLemurHQ For SQL & Data Science Learners

🖍️Code Snippet :
Read 4 tweets
▶️You want to reach an intermediate SQL level inside a week 🔥

💯 I have the recipe for it

Yeah, no kidding. Seriously🫡

Source - Sidharth Kriplani Sir

🧵👇
1⃣Day One:
SQL Bolt (sqlbolt.com)
Data science skill (bit.ly/3i6obPg)
2⃣Day Two:
Average post hiatus (bit.ly/3WRPv2I)
Teams power users (bit.ly/3jCIggI)
Cards issued difference (bit.ly/3YUdhgi)
Read 13 tweets
Day -🔟 on @facebook SQL Questions Series 🚀🎯

& Extremely sorry guys🙏 from last 2 days I am not posted but now onward i will Continue these series 😃🔥

🧵👇
Q10) Assume you have an events table on app analytics. Write a query to get the app’s click-through rate (CTR %) in 2022. Output the results in percentages rounded to 2 decimal places.
🫡Thankyou Shri @NickSinghTechSir For Creating Such a Great Platform @DataLemurHQ For SQL & Data Science Learners

🖍️Code Snippet : Image
Read 4 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!