CASE WHEN
JOIN ON
WHERE&HAVING
分组域筛选;聚合函数;子查询
ORDER BY&IN排序
SQL basic syntax
summary
Building a Hugo static blog from scratch