Contents
Concepts
Basic
Learn SQL Basics
The SELECT and FROM Clauses
The SELECT * EXCLUDE and SELECT * RENAME Clauses
LIMIT
WHERE and Comparison Operators
ORDER BY
AND, OR, and NOT
Arithmetic Operations
IS NULL and IS NOT NULL
LIKE and NOT LIKE
BETWEEN
OFFSET
Intermediate
Working With Joins, Aggregations, and Built-In Functions
Joins
CAST
Aggregations
GROUP BY and FILTER
HAVING
UNION, INTERSECT, and MINUS
POSITION
CASE
IN and NOT IN
Working With Strings
Working With Dates
Working With Arrays
Advanced
WITH
Inline Subqueries
Value blocks
Special Uses of Inline Subqueries
Advanced Aggregate Functions
Windowed Aggregations
ROLLUP and CUBE
PIVOT
UNPIVOT
TABLESAMPLE
Metadata Tables
Lexical Issues
data.world Specific
Multi-Tables
Federated Queries
Parameterized Queries
Special Columns
Query past instances of data
Text formatting for query outputs
Reference
Boolean Aggregations
Regression Aggregations
Standard Aggregations
Statistical Aggregations
Other Aggregations
PRAGMA Statements
Array Functions
All Functions
Date Functions
Formatting Functions
Color Functions
General Functions
Hashing and Related Functions
Linked Data Functions
Math Functions
Security Functions
URL Extraction Functions
String Functions
Aggregations
APPROX_MEDIAN
APPROX_DISTINCT
APPROX_PERCENTILE
ARBITRARY
ARRAY_AGG
BOOL_AND
BOOL_OR
CHECKSUM
AVG
CORRELATION
COUNT_IF
COUNT
COVAR_POP
CUME_DIST
COVAR_SAMP
FIRST_VALUE
DENSE_RANK
GROUP_CONCAT
KURTOSIS
GROUPING
LAST_VALUE
LEAD
MAX
LAG
MAX_BY
MIN
MIN_BY
NTH_VALUE
RANK
NTILE
REGR_AVGY
REGR_COUNT
PERCENT_RANK
REGR_SLOPE
REGR_INTERCEPT
REGR_AVGX
REGR_SXX
REGR_R2
REGR_SXY
REGR_SYY
SKEWNESS
STD_POP
STD_SAMP
ROW_NUMBER
STDEV
VAR_POP
VARIANCE
VAR_SAMP
SUM
Functions
ABS
ACOS
ARRAY
ARRAY_CONCAT
ARRAY_APPEND
ARRAY_JOIN
ARRAY_LOWER
ARRAY_LENGTH
ASIN
ARRAY_CONTAINS
AT_TIME_ZONE
ARRAY_PREPEND
ARRAY_UPPER
ATTR_OF
ATAN2
BOLD
ATAN
CHAR
BASE64_TO_HEX
CEILING
COLOR
COALESCE
COS
CURRENT_USER
CONCAT
COSH
CURRENT_USER_IN_GROUP
DATE_ADD
DATE_DIFF
DATE_PARSE
DATE_FORMAT
DATE_PART
DATE_SUB
DATE_TRUNC
DEGREES
DAY
EXP
ELEMENT_AT
ENDSWITH
EXP10
GENERATE_SERIES
FLOOR
HOURS
GREATEST
HEX_TO_BASE64
IF
IRI_OF
IRI_TO_RESOURCE_HASH
JARO_WINKLER_DISTANCE
LABEL_OF
ITALIC
LENGTH
LEFT
LEAST
LEVENSHTEIN_DISTANCE
LOG
LOG10
LPAD
LTRIM
LOWER
MID
MD5
MINUTES
MOD
MONTH
PI
POSITION
POW
RADIANS
RAND
RANDOM
REGEXP_EXTRACT
REPLACE
REGEX
RGB
REVERSE
ROUND
NOW
RIGHT
RPAD
RTRIM
SECONDS
SHA1
SHA256
SHA384
SHA512
SIN
SIGN
SOUNDEX
SINH
SOUNDEX_DISTANCE
STATUS
SQRT
STR_AFTER
STR_BEFORE
STARTSWITH
STR_CONTAINS
STRING_SPLIT
SUBSTRING
TAN
TANH
TRIM
TRUNC
UPPER
URL_EXTRACT_FRAGMENT
URL_EXTRACT_HOST
URL_EXTRACT_PARAMETER
URL_EXTRACT_PORT
URL_EXTRACT_PATH
URL_EXTRACT_PROTOCOL
URL_EXTRACT_QUERY
WITH_COLOR
WITH_BACKGROUND_COLOR
WITH_LINK
YEAR
WITH_STATUS
Reference
/
Standard Aggregations
A list of standard aggregations.
AVG
COUNT
MIN
MAX
SUM
GROUP_CONCAT