Sachin Kumar Profile picture
Jan 6 โ€ข 5 tweets โ€ข 6 min read
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.
๐Ÿ™ŒThankyou @LeetCode for Providing such a great SQL Questions

๐Ÿ““Code Snippets : Image

โ€ข โ€ข โ€ข

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 9
๐—ช๐—ต๐—ฒ๐—ฟ๐—ฒ to practice SQL in ๐Ÿฎ๐Ÿฌ๐Ÿฎ๐Ÿฏ ๐Ÿ‘จโ€๐Ÿ’ป

Don't panic during your data interviews. Just use these to practice for your SQL technical assessments.

๐Ÿงต๐Ÿ‘‡
๐ŸŽฏ Datalemur - bit.ly/3VQ3nK7

๐ŸŽฏ Leetcode - bit.ly/3uqPGWl

๐ŸŽฏ Strata Scratch - bit.ly/3UynawT

๐ŸŽฏ Hacker Rank - bit.ly/3utazjT
๐ŸŽฏ SQLZoo - lnkd.in/gMRA8r-X

๐ŸŽฏ SQL Pad - lnkd.in/gUCDrjY8

๐ŸŽฏ SQL Lemur - lnkd.in/gQTuHXcQ

Credit - Shri Bemnet Girma
Read 4 tweets
Jan 8
๐ŸŽฏ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 : Image
Read 4 tweets
Jan 7
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
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 :
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

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!

:(