SQL Query

Generate SQL queries for data retrieval, analysis, and reporting.

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