> For the complete documentation index, see [llms.txt](https://liuzhenglaichn.gitbook.io/system-design/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://liuzhenglaichn.gitbook.io/system-design/database/sql.md).

# 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`