Question 17

Table Name: College

Relevant Table: College(Professor (Text), Department (text), Salary (INT))

Professor Department  Salary
John Computer Science 60,000
Van der Mechanical Engineering 57,500
Ackerman Physics 45,000
Suyash Mathematics 52,000
Simrit Computer Science 56,500
Jessica Computer Science 55,000
Jenny Personality Development 50,000

QUERY: Write a query that outputs the SQL statement used to create the above table.

Execute:       SELECT SQL
                      FROM sqlite_master
                     WHERE type = 'table' AND name = 'College';

Answer:

CREATE TABLE College(Professor TEXT, Department TEXT, Salary INT)