1.5 How Analysts Use SQL at Work (Retail, Bank, Clinic Stories)

Why. SQL feels abstract until you hear work stories.

What. Analysts use SQL to filter sales, join customers, and build clean tables for Excel or Power BI.

How. Retail: coffee orders by city. Bank: transactions above a limit. Clinic: appointments this week. Same SQL patterns.

SELECT city, COUNT(*) AS orders
FROM orders
GROUP BY city
ORDER BY orders DESC;