Top Tweets for #TheCodingCo
We use INNER JOIN so employees without managers are excluded automatically.
This self-join pattern is very common in SQL interviews.
Full explanation:
https://t.co/BnscLEIjwI
#SQL #DataAnalytics #SQLInterviewQuestions #TheCodingCo
Important:
RANK() → multiple rows if tie
ROW_NUMBER() → single row
This “aggregate + rank” pattern appears in many SQL interviews.
Full explanation:
https://t.co/P0GG17yHkK
#SQL #DataAnalytics #TheCodingCo #SQLInterviewQuestions
If the question says “per city”:
Add PARTITION BY city
This pattern is very common in time-based SQL problems.
Full explanation:
https://t.co/XIqU0fea9q
#SQL #DataAnalytics #TheCodingCo #SQLInterviewQuestions
If calculation is per customer:
Add PARTITION BY customer_id
This pattern is very common in time-based SQL problems.
Full explanation:
https://t.co/hgZWtrHVh3
#SQL #DataAnalytics #TheCodingCo #SQLInterviewQuestions
Another clean solution is using NOT EXISTS.
Both approaches return customers who never placed an order.
Full explanation:
https://t.co/z8uv7L4Erl
#SQL #DataAnalytics #TheCodingCo #SQLInterviewQuestions
LAG and LEAD
Used to compare rows with other rows nearby.
LAG → previous row
LEAD → next row
These five functions appear in many SQL interview questions.
Full explanation here:
https://t.co/Zc01JFftvV
#SQL #DataAnalytics #TheCodingCo #SQLInterviewQuestions
Interviewers may also ask the difference between:
RANK()
DENSE_RANK()
ROW_NUMBER()
Understanding these three functions is very important.
Full explanation here:
https://t.co/J5fanclqrI
#sql #dataanalytics #thecodingco #sqlinterviewquestions
Another clean solution is using NOT EXISTS, which checks if a matching order exists.
Full explanation here:
https://t.co/cBw93yY05f
#sql #dataanalytics #thecodingco #sqlinterviewquestions
In this video I show two SQL solutions:
• Subquery with COUNT(DISTINCT)
• Window function using DENSE_RANK()
Full explanation:
https://t.co/XKBlX6Apw3
#sql #dataanalytics #thecodingco #sqlinterviewquestions
"What is Arrow Functions ?"
Arrow functions are a concise way to write functions introduced in ES6. They inherit the this context of their enclosing scope, making them great for callbacks.
#thecodingco #javascript #jsconcepts #tipsandtricks
"What is Function Expression?"
A function expression defines a function as part of an expression and is not hoisted. You must define it before calling it.
#thecodingco #javascript #jsconcepts #tipsandtricks
"What is Function Declaration?"
A function declaration defines a named function that can be called before its definition, thanks to hoisting.
#thecodingco #javascript #jsconcepts #tipsandtricks
"What is JavaScript setTimeout()?" ⏲️
- setTimeout() is a JavaScript function that allows you to execute a function after a specified delay in milliseconds.
- It's often used for scheduling tasks to run after a short wait.
#thecodingco #javascript #jsconcepts #tipsandtricks
"What are JavaScript Modules?"📦
Modules allow you to break your code into smaller, reusable files, improving maintainability and readability.
#thecodingco #javascript #jsconcepts #tipsandtricks
Exporting from a Module:
"What is the Rest Operator (...) in JavaScript?"🤔
The Rest Operator lets you collect multiple values into an array or object. It’s great for handling dynamic data!
#thecodingco #javascript #jsconcepts #tipsandtricks
"What is Destructuring in JavaScript?"🤔
Destructuring allows you to extract values from arrays or properties from objects into individual variables in a single statement.
#thecodingco #javascript #jsconcepts
Array Destructuring👇 Object Destructuring👇
"What are JavaScript Arrow Functions?" 🏹
Arrow functions are simpler way to write functions in JavaScript. They just use a compact syntax.
Here’s an simple example:
#thecodingco #javascript #jsconcepts #tipsandtricks
"what is the spread operator (...) in javascript?" 🤔
the spread operator expands elements of an iterable (like an array or object) into individual elements.
(open🧵for examples)👇
#thecodingco #javascript #jsconcepts #tipsandtricks
"what is hoisting in javascript?"🤔
hoisting is javascript's default behavior of moving declarations to the top of their scope before code execution.
#thecodingco #javascript #jsconcepts #tipsandtricks
"what is Event Bubbling in JavaScript?"🌟
event bubbling is when an event starts at the deepest target element and propagates up to its parent elements.
#thecodingco #javascript #jsconcepts #tipsandtricks
Last Seen Hashtags on Sotwe
Trends for you
Most Popular Users
Elon Musk 
@elonmusk
240.1M followers
Barack Obama
@barackobama
119.3M followers
Donald J. Trump
@realdonaldtrump
111.6M followers
Cristiano Ronaldo
@cristiano
108.9M followers
Narendra Modi
@narendramodi
107M followers
Rihanna
@rihanna
97.3M followers
NASA
@nasa
92.1M followers
Justin Bieber
@justinbieber
90.6M followers
KATY PERRY
@katyperry
86.8M followers
Taylor Swift
@taylorswift13
80.6M followers
Lady Gaga
@ladygaga
72.1M followers
Kim Kardashian
@kimkardashian
69.4M followers
YouTube
@youtube
68.6M followers
Virat Kohli
@imvkohli
68.5M followers
Bill Gates
@billgates
63.4M followers
The Ellen Show
@theellenshow
62.5M followers
CNN
@cnn
61.9M followers
Neymar Jr
@neymarjr
61M followers
X
@x
60.9M followers
CNN Breaking News
@cnnbrk
59.9M followers