Learn how to take advantage of data.world's powerful SQL query language here.

The SELECT and FROM Clauses
An introduction to the SELECT
and FROM
clauses and their related keywords
LIMIT
An introduction to the LIMIT
clause.
WHERE and comparison operators
An introduction to the WHERE
clause and comparison operators.
ORDER BY
An introduction to the ORDER BY clause.
AND, OR, and NOT
An introduction to the keywords AND
, OR
and NOT
.
Arithmetic Operations
An introduction to the arithmetic operators +
, -
, *
, \
.
IS NULL and IS NOT NULL
An introduction to the expressions IS NULL
and IS NOT NULL
.
LIKE and NOT LIKE
An introduction to the LIKE
and NOT LIKE
keywords.
BETWEEN
An introduction to the keyword BETWEEN
.
OFFSET
An introduction to the keyword OFFSET
.
Joins
An introduction to table joins including the conditions used in them, and their different types.
CAST
An introduction to the expression CAST
.
Aggregations
An introduction to aggregations, aggregation functions, and aggregation modifiers.
GROUP BY and FILTER
An introduction to the GROUP BY
clause and FILTER
modifier.
HAVING
An introduction to the HAVING
clause.
CASE
An introduction to the CASE
expression.
IN and NOT IN
An introduction to the expressions IN
and NOT IN
.
Working With Dates
An introduction to working with dates.