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
tummybulge
Seen from United Kingdom
painfulanal
Seen from Turkey
GaelRoadtrip
Seen from United States
alpinizem
Seen from Brazil
剣鬼バルゴ
Seen from Thailand
jilbab ngentot
Seen from Indonesia
HIV篩檢
Seen from United States
michieJKT48
Seen from United States
ดูซีรี่ย์จีน
Seen from Thailand
trans
Seen from United States
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