Visualizador de consultas SQL

⊞Tabelas

8entidades na consulta

☍Relacionamentos

77 INNER · 0 LEFT

⑂CTEs

3subconsultas nomeadas

⊣LEFT JOINs

0junções externas

Editor SQL

51 lin·1624 car

WITH cust_order_summary AS (
    SELECT 
        c.customer_id,
        c.first_name || ' ' || c.last_name AS customer_name,
        c.email,
        COUNT(DISTINCT o.order_id) AS total_orders,
        SUM(oi.quantity * oi.unit_price) AS total_spent,
        MAX(o.order_date) AS last_order_date
    FROM customers c
    INNER JOIN orders o ON c.customer_id = o.customer_id
    INNER JOIN order_items oi ON o.order_id = oi.order_id
    INNER JOIN payments p ON o.order_id = p.order_id
    WHERE o.order_status = 'Completed'
      AND p.payment_status = 'Approved'
    GROUP BY c.customer_id, c.first_name, c.last_name, c.email
),

category_spending AS (
    SELECT 
        o.customer_id,
        cat.category_name,
        SUM(oi.quantity * oi.unit_price) AS category_total_spent
    FROM orders o
    INNER JOIN order_items oi ON o.order_id = oi.order_id
    INNER JOIN products p ON oi.product_id = p.product_id
    INNER JOIN categories cat ON p.category_id = cat.category_id
    WHERE o.order_status = 'Completed'
    GROUP BY o.customer_id, cat.category_name
),

favorite_category AS (
    SELECT 
        customer_id,
        category_name AS preferred_category,
        ROW_NUMBER() OVER(PARTITION BY customer_id ORDER BY category_total_spent DESC) AS rn
    FROM category_spending
)

SELECT 
    cos.customer_id,
    cos.customer_name,
    cos.email,
    cos.total_orders,
    cos.total_spent,
    cos.last_order_date,
    fc.preferred_category
FROM cust_order_summary cos
INNER JOIN favorite_category fc ON cos.customer_id = fc.customer_id
WHERE fc.rn = 1
  AND cos.total_spent > 500
ORDER BY cos.total_spent DESC;

Diagrama de Relacionamentos

11 nós · 10 arestas

LINKLESS · SQL

Aprenda a usar o Analisador SQL

Como usar o analisador

Um passo a passo para analisar uma consulta e explorar as métricas e o diagrama.

Ler guia →02

Como interpretar o diagrama

Entenda nós, junções, CTEs e os limites da visualização.

Ler guia →