SQL Parser

SELECT 
  u.id, 
  u.name, 
  u.email,
  COUNT(o.id) as order_count,
  SUM(o.total) as total_spent
FROM users u
LEFT JOIN orders o ON u.id = o.user_id
WHERE u.created_at >= '2024-01-01'
  AND u.status = 'active'
GROUP BY u.id, u.name, u.email
HAVING COUNT(o.id) > 5
ORDER BY total_spent DESC
LIMIT 10;

Parsed SQL Structure:

Query Type: SELECT
Dialect: Standard SQL (compatible with PostgreSQL, MySQL, SQLite)

SELECT Clause:
  Columns:
    - u.id (from users table)
    - u.name (from users table)
    - u.email (from users table)
    - COUNT(o.id) AS order_count (aggregate function)
    - SUM(o.total) AS total_spent (aggregate function)

FROM Clause:
  Primary Table: users (alias: u)

JOIN Clauses:
  - Type: LEFT JOIN
    Table: orders (alias: o)
    Condition: u.id = o.user_id
    Relationship: One-to-Many (users → orders)

WHERE Clause:
  Conditions:
    1. u.created_at >= '2024-01-01' (date filter)
       Operator: >=
       Type: Date comparison
    
    2. u.status = 'active' (status filter)
       Operator: =
       Type: String equality
    
  Logic: AND (both conditions must be true)

GROUP BY Clause:
  Grouping Columns:
    - u.id
    - u.name
    - u.email
  Purpose: Aggregate orders per user

HAVING Clause:
  Condition: COUNT(o.id) > 5
  Purpose: Filter users with more than 5 orders
  Applied After: GROUP BY aggregation

ORDER BY Clause:
  Sort Column: total_spent
  Direction: DESC (descending, highest first)

LIMIT Clause:
  Row Count: 10 (top 10 results)

Tables Referenced:
  1. users (alias: u)
     Columns: id, name, email, created_at, status
  
  2. orders (alias: o)
     Columns: id, user_id, total

Aggregate Functions:
  - COUNT(o.id): Counts orders per user
  - SUM(o.total): Sums order totals per user

Query Purpose:
  Find top 10 active users (created after 2024-01-01) 
  with more than 5 orders, sorted by total spending

Performance Considerations:
  ✓ Uses indexes on: users.created_at, users.status, orders.user_id
  ⚠️ LEFT JOIN may include users with 0 orders (filtered by HAVING)
  ✓ LIMIT 10 reduces result set size