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

https://www.red-gate.com/simple-talk/

Querynomicon - An Introduction to SQL for the Cautious and Weary: https://third-bit.com/sql/

[flagged]