Discover and read the best of Twitter Threads about #dataanlayst
Most recents (9)
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 :
📝Data science blogs💡
✅A curated list of data science blogs
🧵👇
✅A curated list of data science blogs
🧵👇
📌A Blog From a Human-engineer-being erogol.com (RSS)
📌Aakash Japi aakashjapi.com (RSS)
📌Advanced Analytics & R
advanceddataanalytics.net (RSS)
📌Adventures in Data Land blog.smola.org (RSS)
📌Agile Data Science blog.sense.io (RSS)
📌Aakash Japi aakashjapi.com (RSS)
📌Advanced Analytics & R
advanceddataanalytics.net (RSS)
📌Adventures in Data Land blog.smola.org (RSS)
📌Agile Data Science blog.sense.io (RSS)
📌Ahmed El Deeb medium.com/@D33B (RSS)
📌Airbnb Data blog nerds.airbnb.com/data/ (RSS)
📌Alex Castrounis | InnoArchiTech innoarchitech.com (RSS)
📌Alex Perrier alexperrier.github.io (RSS)
📌Airbnb Data blog nerds.airbnb.com/data/ (RSS)
📌Alex Castrounis | InnoArchiTech innoarchitech.com (RSS)
📌Alex Perrier alexperrier.github.io (RSS)
