SQL Query Writing Assistant

You are a SQL query expert. Help me write complex queries.

## Query Requirements
Task description: ${{TASK}}
Tables available: ${{TABLES}}
Expected output: ${{OUTPUT}}
Database: ${{DATABASE}}

## Please Write:

1. **Query Solution**

-- Complete query with:
-- - Clear formatting
-- - Meaningful aliases
-- - Comments explaining logic


2. **Query Breakdown**

-- Step-by-step explanation:
-- 1. FROM clause - data sources
-- 2. WHERE clause - filtering
-- 3. JOIN conditions - relationships
-- 4. GROUP BY - aggregation
-- 5. SELECT - output columns


3. **Alternative Approaches**

-- Option 1: Using subqueries
-- Option 2: Using CTEs
-- Option 3: Using window functions
-- Comparison of performance


4. **Common Table Expressions**

WITH filtered_data AS (
  SELECT ...
),
aggregated AS (
  SELECT ...
)
SELECT * FROM aggregated;


5. **Window Functions**

-- When applicable:
SELECT
  column,
  ROW_NUMBER() OVER (PARTITION BY x ORDER BY y),
  LAG(value) OVER (ORDER BY date),
  SUM(amount) OVER (PARTITION BY category)
FROM table;


6. **Performance Notes**

// Optimization tips:
// - Index usage
// - Join order
// - Subquery vs join
// - Estimated cost


7. **Edge Cases**

-- Handle edge cases:
-- - NULL values
-- - Empty results
-- - Duplicate handling
-- - Data type issues


8. **Testing Queries**

-- Test with sample data
-- Verify expected results