What is SQL query example?

Could you please provide an example of a SQL query and explain its purpose? I'm a bit new to the concept and would appreciate a clear explanation. Specifically, I'm interested in understanding how a SQL query can be used to retrieve data from a database, such as selecting specific rows or columns from a table. Can you give me a simple example and walk me through the process? Thank you for your help!