loqLog Query

-- Aggregations
SELECT department, COUNT(*), AVG(salary)
FROM employees.csv
GROUP BY department
HAVING COUNT(*) > 5;

-- Window functions
SELECT name, salary,
       RANK() OVER (PARTITION BY dept ORDER BY salary DESC) as rank
FROM employees.csv;

-- JOINs
SELECT u.name, o.total
FROM users.csv u
INNER JOIN orders.csv o ON u.id = o.user_id;

-- Subqueries
SELECT * FROM products.csv
WHERE price > (SELECT AVG(price) FROM products.csv);