SQL Query

Capabilities

• Generate SELECT, INSERT, UPDATE, DELETE queries
• Build complex JOINs and subqueries
• Aggregate data with GROUP BY and window functions
• Optimize query performance

Query Patterns

Basic Select

SELECT column1, column2
FROM table_name
WHERE condition
ORDER BY column1
LIMIT 100;

Aggregation

SELECT category, COUNT(*) as count, AVG(price) as avg_price
FROM products
GROUP BY category
HAVING COUNT(*) > 10;

Window Functions

SELECT
    name,
    department,
    salary,
    RANK() OVER (PARTITION BY department ORDER BY salary DESC) as rank
FROM employees;

Best Practices

1. Always use parameterized queries to prevent SQL injection
2. Index columns used in WHERE and JOIN clauses
3. Avoid SELECT * in production queries
4. Use EXPLAIN to analyze query performance