How to do a SQL Server query?

I'm curious about performing SQL Server queries. Could you please guide me through the process step-by-step? What are the basic elements of a SQL query, and how do I structure them to retrieve data from a database? Additionally, are there any best practices or common pitfalls to avoid when crafting SQL queries? I'd appreciate any insights or tips you have on optimizing query performance and ensuring data integrity.