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