Discover and read the best of Twitter Threads about #60daysofsql
Most recents (11)
🔗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).
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 :
Q16 ) Write an SQL query to report all customers who never order anything.
Return the result table in any order.
Return the result table in any order.
Hey Folks 😃
📗Here are my Last 15 days Of SQL Questions Series Practice
🧵👇
📗Here are my Last 15 days Of SQL Questions Series Practice
🧵👇
Day 1 -
Day 2 -
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.
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 :
@DataLemurHQ For SQL & Data Science Learners
🖍️Code Snippet :
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
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 :
🖍️Code Snippet :
▶️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
🧵👇
💯 I have the recipe for it
Yeah, no kidding. Seriously🫡
Source - Sidharth Kriplani Sir
🧵👇
2⃣Day Two:
Average post hiatus (bit.ly/3WRPv2I)
Teams power users (bit.ly/3jCIggI)
Cards issued difference (bit.ly/3YUdhgi)
Average post hiatus (bit.ly/3WRPv2I)
Teams power users (bit.ly/3jCIggI)
Cards issued difference (bit.ly/3YUdhgi)
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 😃🔥
🧵👇
& 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 :
🖍️Code Snippet :
