Description

Question 1: Complete the given CREATE TABLE command to create an (empty) table test that has the following structure and constraints.

Table “public.test”
Column | Type | Constraints
——–+———————–+————— sno | character varying(3) | primary key sname | character varying(10) | not null status | integer | status > 20
city | character varying(10) | cannot start with letter ‘R’

CREATE TABLE test (sno VARCHAR (3) _____________, sname _________________________, status INTEGER ___________________,
city VARCHAR(10) _____________________);

Question 2a. What is the result of SELECT * FROM test; after the scenario given below?

2b. What is the result of SELECT * FROM test; after the scenario given below?

Question 3. Complete the following CREATE TABLE command that creates a table called temp from existing tables S and SP (use these tables from lab2). It stores supplier name and the total number of parts supplied by each supplier as shown below:

chaturvr=> SELECT * FROM temp; sname | # of Parts ——-+————
SMITH | 1
CLARK | 1
JONES | 2
BLAKE | 2
ADAMS | 6
(5 rows)

CREATE TABLE temp AS ____________________________