SQL Queries

Question 1

Insert command

Answer 1

INSERT INTO EMPLOYEE (name, age, etc)
VALUES (‘Richard’, 25, etc)

or

INSERT INTO EMPLOYEE (name, age, etc)
SELECT name, age, etc
FROM tempemployee
WHERE age > 25

Question 2

Create table following template

Answer 2

CREATE TABLE HELLO LIKE BONJOUR
(SELECT
FROM
WHERE)
WITH DATA;

Question 3

DELETE

Answer 3

DELETE FROM EMPLOYEE
WHERE Lname=’Richard’;

Question 4

UPDATE

Answer 4

UPDATE PROJECT
SET Plocation=’Bellaire’, Dnum=5
WHERE Pnumber=10;

Question 5

Give all employees in research department a 10% increase

Answer 5

UPDATE EMPLOYEE
SET SALARY=SALARY*1.1
WHERE Do IN(SELECT DNUMBER
FROM DEPARTMENT
WHERE DNAME=’Research’);

Question 6

Create a view

Answer 6

CREATE VIEW blah blah AS
SELECT
FROM
WHERE