NLP__SQL/0/quires/sql.quires

CREATE TABLE students (
  id         INTEGER PRIMARY KEY AUTOINCREMENT,
  first_name TEXT NOT NULL,
  last_name  TEXT NOT NULL,
  grade      REAL NOT NULL
);

SELECT
  name
FROM
  sqlite_master
WHERE
  type = 'table';

SELECT 
  name
FROM 
  sqlite_master
WHERE 
  type = 'table';

SELECT
  name
FROM
  sqlite_master
WHERE
  type = 'table';

CREATE TABLE students (
  id         INTEGER PRIMARY KEY AUTOINCREMENT,
  first_name TEXT NOT NULL,
  last_name  TEXT NOT NULL,
  grade      REAL NOT NULL
);
CREATE TABLE random_table (
  id         INTEGER PRIMARY KEY AUTOINCREMENT,
  first_name TEXT NOT NULL,
  last_name  TEXT NOT NULL,
  grade      REAL NOT NULL
);
SELECT
  *
FROM
  students
WHERE
  first_name = 'John';

SELECT
  *
FROM
  students;

PRAGMA table_info(students);

PRAGMA table_info(students);
SELECT
  *
FROM
  students;
SELECT
  name
FROM
  sqlite_master
WHERE
  type = 'table';

SELECT
  name
FROM
  sqlite_master
WHERE
  type = 'table';

SELECT
  name
FROM
  sqlite_master
WHERE
  type = 'table';

SELECT
  name
FROM
  sqlite_master
WHERE
  type = 'table';

SELECT
  name
FROM
  sqlite_master
WHERE
  type = 'table';

SELECT
  name
FROM
  sqlite_master
WHERE
  type = 'table';

SELECT
  name
FROM
  sqlite_master
WHERE
  type = 'table';

SELECT
  name
FROM
  sqlite_master
WHERE
  type = 'table';

SELECT 
  name
FROM 
  sqlite_master
WHERE 
  type = 'table';

SELECT 
  name
FROM 
  sqlite_master
WHERE 
  type = 'table';

SELECT
  name
FROM
  sqlite_master
WHERE
  type = 'table';

SELECT
  name
FROM
  sqlite_master
WHERE
  type = 'table';

SELECT 
  name
FROM 
  sqlite_master
WHERE 
  type = 'table';

SELECT
  name
FROM
  sqlite_master
WHERE
  type = 'table';

SELECT
  name
FROM
  sqlite_master
WHERE
  type = 'table';

SELECT
  name
FROM
  sqlite_master
WHERE
  type = 'table';

SELECT name
FROM sqlite_master
WHERE type = 'table';

SELECT
  name
FROM
  sqlite_master
WHERE
  type = 'table';

SELECT
  name
FROM
  sqlite_master
WHERE
  type = 'table';

SELECT 
  name
FROM 
  sqlite_master
WHERE 
  type = 'table';

SELECT
  name
FROM
  sqlite_master
WHERE
  type = 'table';

SELECT name
FROM sqlite_master
WHERE type = 'table';

SELECT
  name
FROM
  sqlite_master
WHERE
  type = 'table';

SELECT
  name
FROM
  sqlite_master
WHERE
  type = 'table';

SELECT name
FROM sqlite_master
WHERE type = 'table';

SELECT 
  name
FROM 
  sqlite_master
WHERE 
  type = 'table';

SELECT
  name
FROM
  sqlite_master
WHERE
  type = 'table';

SELECT 
  name
FROM 
  sqlite_master
WHERE 
  type = 'table';

SELECT 
  name
FROM 
  sqlite_master
WHERE 
  type = 'table';