🎯 𝐒𝐐𝐋 𝐒𝐞𝐫𝐢𝐞𝐬 | 𝐄𝐩. 𝟗 — 𝐈𝐍𝐍𝐄𝐑 𝐉𝐎𝐈𝐍: 𝐂𝐨𝐧𝐧𝐞𝐜𝐭𝐢𝐧𝐠 𝐓𝐚𝐛𝐥𝐞𝐬 𝐭𝐨 𝐓𝐞𝐥𝐥 𝐚 𝐒𝐭𝐨𝐫𝐲

Every business insight starts with a question — but often, 𝐭𝐡𝐞 𝐚𝐧𝐬𝐰𝐞𝐫 𝐢𝐬 𝐡𝐢𝐝𝐝𝐞𝐧 𝐚𝐜𝐫𝐨𝐬𝐬 𝐦𝐮𝐥𝐭𝐢𝐩𝐥𝐞 𝐭𝐚𝐛𝐥𝐞𝐬.
That’s where 𝐈𝐍𝐍𝐄𝐑 𝐉𝐎𝐈𝐍 steps in — it connects the dots and turns isolated datasets into one powerful story.

Let’s see how 👇

💡𝐂𝐨𝐧𝐜𝐞𝐩𝐭 𝐁𝐫𝐞𝐚𝐤𝐝𝐨𝐰𝐧: 𝐈𝐍𝐍𝐄𝐑 𝐉𝐎𝐈𝐍

𝐈𝐍𝐍𝐄𝐑 𝐉𝐎𝐈𝐍 returns only the rows that have matching values in both tables.
It’s like saying — “Show me only the records that exist in both worlds.”

This is the backbone of relational databases — connecting 𝐜𝐮𝐬𝐭𝐨𝐦𝐞𝐫𝐬 𝐭𝐨 𝐭𝐡𝐞𝐢𝐫 𝐨𝐫𝐝𝐞𝐫𝐬, 𝐬𝐭𝐮𝐝𝐞𝐧𝐭𝐬 𝐭𝐨 𝐭𝐡𝐞𝐢𝐫 𝐠𝐫𝐚𝐝𝐞𝐬, 𝐨𝐫 𝐮𝐬𝐞𝐫𝐬 𝐭𝐨 𝐭𝐡𝐞𝐢𝐫 𝐚𝐜𝐭𝐢𝐨𝐧𝐬.

🔍 𝐄𝐱𝐚𝐦𝐩𝐥𝐞: 𝐇𝐢𝐠𝐡𝐞𝐬𝐭 𝐂𝐨𝐬𝐭 𝐎𝐫𝐝𝐞𝐫𝐬 — https://lnkd.in/gz4nu4f4

🧾 𝐓𝐡𝐞 𝐐𝐮𝐞𝐬𝐭𝐢𝐨𝐧:
Find the customers with the highest daily total order cost between Feb 1, 2019 and May 1, 2019.
If a customer placed multiple orders on the same day, sum their total costs.
Return each customer’s 𝐟𝐢𝐫𝐬𝐭 𝐧𝐚𝐦𝐞, 𝐝𝐚𝐢𝐥𝐲 𝐭𝐨𝐭𝐚𝐥, 𝐚𝐧𝐝 𝐝𝐚𝐭𝐞 — including ties.

🧠 𝐓𝐡𝐞 𝐐𝐮𝐞𝐫𝐲:

Get Somyagupta’s stories in your inbox

Join Medium for free to get updates from this writer.

Remember me for faster sign in

SELECT
c.first_name,
o.order_date,
SUM(o.total_order_cost) AS daily_total
FROM orders o
INNER JOIN customers c
ON o.cust_id = c.id
WHERE o.order_date BETWEEN ‘2019–02–01’ AND ‘2019–05–01’
GROUP BY c.first_name, o.order_date
HAVING SUM(o.total_order_cost) = (

SELECT MAX(daily_sum)
FROM (SELECT order_date, SUM(total_order_cost) AS daily_sum
FROM orders
WHERE order_date BETWEEN ‘2019–02–01’ AND ‘2019–05–01’
GROUP BY order_date, cust_id) t );

🧩 𝐊𝐞𝐲 𝐏𝐨𝐢𝐧𝐭𝐬:

✅ 𝐈𝐍𝐍𝐄𝐑 𝐉𝐎𝐈𝐍 links orders with customers through cust_id = id.
✅ The 𝐖𝐇𝐄𝐑𝐄 clause filters the time frame (Feb–May 2019).
✅ The first 𝐆𝐑𝐎𝐔𝐏 𝐁𝐘 aggregates each customer’s daily total.
✅ The subquery finds the maximum daily spend across all customers and dates.
✅ The 𝐇𝐀𝐕𝐈𝐍𝐆 clause ensures we only keep those matching that highest value.

💬 𝐖𝐡𝐲 𝐈𝐭 𝐌𝐚𝐭𝐭𝐞𝐫𝐬:

In business, 𝐈𝐍𝐍𝐄𝐑 𝐉𝐎𝐈𝐍 lets you answer multi-dimensional questions - 𝐧𝐨𝐭 𝐣𝐮𝐬𝐭 𝐰𝐡𝐨 𝐨𝐫𝐝𝐞𝐫𝐞𝐝, 𝐛𝐮𝐭 𝐰𝐡𝐞𝐧, 𝐡𝐨𝐰 𝐦𝐮𝐜𝐡, 𝐚𝐧𝐝 𝐡𝐨𝐰 𝐭𝐡𝐞𝐲 𝐜𝐨𝐦𝐩𝐚𝐫𝐞 𝐭𝐨 𝐨𝐭𝐡𝐞𝐫𝐬.

You’re no longer just querying tables — you’re uncovering stories of customer behavior and business value.

📘 𝐓𝐫𝐲 𝐈𝐭 𝐘𝐨𝐮𝐫𝐬𝐞𝐥𝐟:

🔗 𝐒𝐞𝐧𝐝𝐢𝐧𝐠 𝐯𝐬. 𝐎𝐩𝐞𝐧𝐢𝐧𝐠 𝐒𝐧𝐚𝐩𝐬 (https://lnkd.in/gqmBsNi8)
🔗 𝐑𝐚𝐧𝐤 𝐕𝐚𝐫𝐢𝐚𝐧𝐜𝐞 𝐏𝐞𝐫 𝐂𝐨𝐮𝐧𝐭𝐫𝐲 (https://lnkd.in/gYCsAACk)

🚀 𝐂𝐨𝐦𝐢𝐧𝐠 𝐮𝐩 𝐧𝐞𝐱𝐭:
𝐄𝐩. 𝟏𝟎 — 𝐋𝐄𝐅𝐓, 𝐑𝐈𝐆𝐇𝐓 & 𝐅𝐔𝐋𝐋 𝐎𝐔𝐓𝐄𝐑 𝐉𝐎𝐈𝐍: 𝐊𝐞𝐞𝐩𝐢𝐧𝐠 𝐌𝐢𝐬𝐬𝐢𝐧𝐠 𝐃𝐚𝐭𝐚