Deep dive into Select Statements

Hai semuanya, di materi sebelumnya kita sudah membahas basic tentang Select Statements, Build-in functions and operators, WHERE clause, Limit and Offset, dan yang terakhir Sorting menggunakan Order By clause. Sekakarang kita akan membahas lebih detail tentang Select statement diantarnaya:

1. Single Row functions
2. Group functions
3. Joined Tables
4. Sub-queries
5. Conditional Expression
6. Combining Queries
7. With Queries