Summary
I've been working on a web application for 2 months now, which has forced me to improve my knowledge of sql. It took some dedication to get more or less considerable results, so here are some tips for those who want to build more complex and efficient queries.
Indexing frequently used columns in `WHERE' and 'JOIN' can improve performance. Use the EXPLAIN command to see how the database processes your queries and identify bottlenecks.