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.