Mode Analytics tutorial is well laid out:

https://mode.com/sql-tutorial/