Sachin Kumar Profile picture
Jan 2 โ€ข 4 tweets โ€ข 6 min read
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 :

โ€ข โ€ข โ€ข

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

Jan 3
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 : Image
Read 4 tweets
Jan 3
3 SQL Games that will take your SQL skills to the next level

๐Ÿงต๐Ÿ‘‡
๐Ÿ. ๐’๐๐‹ ๐Œ๐ฎ๐ซ๐๐ž๐ซ ๐Œ๐ฒ๐ฌ๐ญ๐ž๐ซ๐ฒ

A murder has happened in SQL city!

Can you use your SQL knowledge to find the killer?

๐Ÿ‘‰ lnkd.in/gg5UedDQ
๐Ÿ. ๐’๐๐‹ ๐๐จ๐ฅ๐ข๐œ๐ž ๐ƒ๐ž๐ฉ๐š๐ซ๐ญ๐ฆ๐ž๐ง๐ญ

Join SQLPD, and solve crimes while learning SQL in the process!

๐Ÿ‘‰ sqlpd.com
Read 5 tweets
Jan 2
โ–ถ๏ธ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
Jan 1
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
Dec 23, 2022
Free SQL Resources for beginners!

Spend $0 and earn yourself some SQL knowledge with these sites.

Post Credit - Travis Tang Sir

๐Ÿงต๐Ÿ‘‡
1๏ธโƒฃ ๐™†๐™๐™–๐™ฃ ๐˜ผ๐™˜๐™–๐™™๐™š๐™ข๐™ฎ's Intro to SQL: Querying and Managing Data comes with video lessons and interactive coding exercises.
(lnkd.in/g5y_Pfvf)
2๏ธโƒฃ ๐˜พ๐™ค๐™™๐™š๐™–๐™˜๐™–๐™™๐™š๐™ข๐™ฎ provides a treasure trove of text tutorials for beginners and intermediates alike. (lnkd.in/gZ5_uYjC)
Read 6 tweets
Dec 22, 2022
๐Ÿ’กDay -2 on SQL Questions

๐Ÿงต๐Ÿ‘‡
Q2) Assume you are given the tables below about Facebook pages and page likes. Write a query to return the page IDs of all the Facebook pages that don't have any likes. The output should be in ascending order. ( Questions Link is also Provided )
๐Ÿ™ŒThankyou so much Shri @NickSinghTechSir For
Creating Such a Great Platform @DataLemurHQ For
SQL & Data Science Learners

๐Ÿ–๏ธCode Snippet :
Read 4 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!

:(