SQL Query: Electronics

electronics.sql

SELECT
    u.name AS user_name,
    u.email AS user_email,
    SUM(o.quantity * p.price) AS total_spent
FROM
    users u
JOIN
    orders o ON u.id = o.user_id
JOIN
    products p ON o.product_id = p.id
WHERE
    p.category = 'Electronics'
GROUP BY
    u.id, u.name, u.email
HAVING
    COUNT(o.id) >= 3 AND SUM(o.quantity * p.price) > 1000
ORDER BY
    total_spent DESC;