Executing multiple statements
53.2
Exercise

Executing multiple SQL statements

Write a set of SQL statements together to:

  1. create a new table teachers with the following columns and data types.

    column data type
    id INTEGER
    name TEXT
    age INTEGER
  2. add these record rows to the created table teachers

    id (INTEGER) name (TEXT) age (INTEGER)
    1 Heisenburg 32
    2 Feynman 28
    3 Rutherford 35