I thought Practical SQL was very good at explaining both the how and the why with practical real-world examples.

https://nostarch.com/practical-sql-2nd-edition