📌 SQL Interview Question (Must-Know)

Question:

You have a table orders with the following columns:
order_id, customer_id, order_date, order_amount

👉 Write an SQL query to find the total order amount for each customer who has placed more than 3 orders.

✅ Solution:

SELECT
customer_id,
SUM(order_amount) AS total_order_amount
FROM orders
GROUP BY customer_id
HAVING COUNT(order_id) > 3;

🧠 Explanation:

GROUP BY customer_id → groups orders per customer

SUM(order_amount) → calculates total spending

HAVING COUNT(order_id) > 3 → filters customers with more than 3 orders

👍 React with 🔥 or 👍 if this helped

📊 Want more SQL interview questions & real-world scenarios? React and stay tuned!