SQL query builder · Higher Computing teacher tools

Database Task

Query design

Table(s)

Field(s)

Aggregate (optional)

Function Of As

GROUP BY

Field

Search criteria

Sort order

Changing the design rewrites the SQL and runs it.

SQL

SQL statement

Output

The database

row used by the selected output rowadded or changeddeleted

Primary keys are underlined. Foreign keys are marked *.

Real SQLite running in this browser. Higher SQL: SELECT with aggregates (COUNT, SUM, AVG, MAX, MIN) and GROUP BY, wildcards with LIKE, computed values and aliases, saved queries and subqueries, WHERE (AND, OR, =, <, >, <=, >=), ORDER BY, the equi-join, INSERT, UPDATE and DELETE.