Refactoring to CTEs

This nested query is hard to read:

SELECT * FROM customers
WHERE id IN (
    SELECT customerId FROM orders
    WHERE id IN (
        SELECT orderId FROM orderItems
        WHERE productId IN (
            SELECT id FROM products WHERE category = 'Electronics'
        )
    )
);

Your Task

Refactor this to use CTEs! Create:

• electronics_products - IDs of Electronics products
• electronics_orders - Order IDs containing electronics
• electronics_customers - Customer IDs who ordered electronics

Then select customer name and email from your final CTE joined with customers.