3.1

IN operator

A clause used to determine if a value matches one of several specified values.

BETWEEN operator

An alternative method to determine if a value is between two other specified values, inclusive.

LIKE operator

Used for pattern matching in SQL, allowing for wildcard characters.

Wildcard character

Represents one or more unspecified characters in pattern matching.

BINARY keyword

Used with the LIKE operator to enforce case-sensitive pattern matching.

SELECT statement

A SQL command used to select data from a database.

DISTINCT clause

Used with SELECT to return only unique or distinct values.

ISOfficial

A column indicating whether a language is officially recognized in a country.

ORDER BY clause

Used to sort the result set of a query by one or more columns.

DESC keyword

Specifies descending order in the ORDER BY clause.