SQL

Question 1

Create database

Answer 1

CREATE DATABASE company;

Question 2

create tables

Answer 2

CREATE TABLE employee
(first varchar(15),
last varchar(20),
age number(3),
address varchar(30),
city varchar(20),
county varchar(20));

Question 3

insert

Answer 3

INSERT INTO employee (first,last,age,address,city,county) VALUES (‘Bob’, ‘dylan’ , ‘72, 79b causeway st’ , ‘portrush’, ‘antrim’);

Question 4

retrieve

Answer 4

SELECT first,last FROM employee WHERE city=’Belfast’;

Question 5

update

Answer 5

UPDATE employee SET county = ‘antrim’ WHERE city= ‘belfast’;

Question 6

delete

Answer 6

DELETE from employee WHERE city= ‘belfast’;