Basics
What’s the SQL command you use to start any query?
SELECT
Two best friends who only hang out if they both show up. What join is this?
INNER JOIN
Your mum checking how many times you asked for snacks this month—what SQL function is she using?
COUNT()
You want your playlist sorted from most played to least played songs. What SQL keyword does this?
ORDER BY
You go to a party, and everyone has the same name. What SQL feature can make sure everyone has a unique ID?
PRIMARY KEY
If SELECT is asking for something, what keyword tells SQL where to get it from?
FROM
Your ex still keeps all your photos, but you erased all of theirs. What join is this?
A shopkeeper calculating total revenue at the end of the day—what function is this?
SUM()
Your spam folder filters out duplicate emails—what SQL keyword does that?
DISTINCT
Your mum makes a rule: you can’t eat dessert unless you finish your veggies. What SQL feature enforces this dependency?
FOREIGN KEY
Your database filters rows from a table based on a condition. What SQL clause is being used?
WHERE
Your boss remembers all employees, but employees only remember their current manager. What join is this?
RIGHT JOIN
Your parents check all your test scores and try to figure out if you’re a genius or just ‘consistently average.’ What function are they using?
AVG()
The bouncer lets in only the first 5 people in line—what SQL keyword?
LIMIT
Your phone contacts list shows ‘Mario's Pizza Place’ five times. What SQL keyword helps you clean up this tragedy?
DISTINCT
If = is used for equality, what operator would you use for ‘not equal to’
!=
An online dating app where you can see both who liked you and whom you liked—what join is this?
FULL OUTER JOIN
Your teacher wants to see how many excuses each student gave for not doing homework. What SQL clause helps group the excuses by student?
GROUP BY
You want to find students who scored in a range of 80 and 90%. What keyword do you use?
BETWEEN
You text your secret crush, and they leave your message unread. What’s the SQL data equivalent of this heartbreak?
NULL
You only want to filter for students who scored above 80% and submitted their assignments. Which operator do you use?
AND, &&
You want to find all customers who placed an order… and those who just window-shopped but never bought anything. What type of JOIN helps you catch these sneaky non-buyers?
LEFT JOIN
You check how many times each friend has borrowed money from you, but you only care about those who owe you more than ₹500. What SQL clause helps you filter them out?
Having
You text your friends: ‘Who’s up for a movie?’ Only Alice, Bob, and Charlie reply ‘Yes.’ Instead of checking with each person one by one, what SQL keyword lets you find them all at once?
IN
You want to sound fancy, so instead of ‘eating snacks,’ you tell people you’re ‘engaging in culinary exploration.’ What SQL trick lets you rename things?
Alias(AS)