SQL

Common SQL operations:

filter: where gender = F
projection: select first_name, last_name from ...
join: select ... from employee t1, salary t2 where t1.emp_id = t2.id
aggregation: select count(*) from ... group by gender