A SQL condition that filters results from a `SELECT` query
Symbols used in conditions (`=`, `!=`, `>`, `<`, `>=`, `<=`)
A logical expression that restricts what data is returned
To narrow down a set of results based on rules
A logical operator that requires multiple conditions to be true
A SQL operator used to filter results within a range (inclusive)
A SQL operator used for pattern matching in text data
A SQL operator that checks if a value matches any value in a given list
A condition that uses multiple filters together
A SQL clause that sorts the returned query results by one or more columns
Ascending order; the default sort direction
Descending order; used to reverse the default sorting
A SQL operation that combines rows from two or more tables based on a related column.
A join where each row in one table is paired with every row in another.
A field in one table that refers to the primary key in another table.
A temporary name assigned to a column or table using the `AS` keyword in SQL
A SQL keyword used to rename fields or tables in the query result