SQL

id INTEGER
name TEXT
age INTEGER

SELECT * FROM items

• Table

  • a collection of data organized into rows and columns. Tables are sometimes referred to as relations. The table would be items

• Column

  • A set of data values of a particular type. id, name, and age are the columns

  • All data stored in a relation database is of a certain data type.

• Clauses

  • SELECT and FROM are the clauses