-- Choose one column
select email from users;

-- Choose more columns
select email, firstName, lastName from users;

-- Choose all columns
select * from users;

-- Use 'DISTINCT' to choose all unique data
select distinct role from users;

-- SQL aliases are used to give a table, or a column in a table, a temporary name.
select notified_delete_account_at as n from users;

-- You can combine alias with other columns
select notified_delete_account_at as n, firstName from users;

-- Use 'where' condition as a search condition
select firstName, lastName, email from users where firstName = 'Sterling';

-- Use 'or' condition to choose one of the statements
select firstName, lastName, email from users where firstName = 'Sterling' or firstName = 'pm';

-- Use 'and' condition to choose both statements
select firstName, lastName, email from users where firstName = 'Sterling' and lastName = 'Lind';

-- Finds any values that end with "patso.com"
select email from users where email like '%patso.com';

-- Finds any values that have "@patso" in the third position
select email from users where email like '__@patso%';

-- Use 'NULL' operator to choose all null or not null values
select email, deleted_at from users where deleted_at is null;

-- Another example with not null
select email, deleted_at from users where deleted_at is not null;

-- The 'BETWEEN' operator selects values within a given range. The values can be numbers, text, or dates.
select * from users where id between 99999998 and 100000010;

-- The 'ORDER BY' keyword is used to sort the result-set in ascending or descending order.
select * from users order by created_at asc;

select * from users order by created_at desc;

-- The 'LIMIT' keyword is used to limit the number of rows returned in a query result
select * from users order by created_at desc limit 4;