I know how to write SQL queries and can get the results I need. But sometimes my queries are slow and I don't fully understand why.
What are some good resources for learning to write efficient queries and to optimize the queries I've already written?