Can you give an example of an SQL query for data retrieval from a table?

Example of a simple SQL query to select data from the "users" table:

SELECT id, name, email FROM users WHERE active = 1;

This query selects the columns id, name, and email from the users table only for records where the active field equals 1 (for example, active users).