SQL

Question 1

State SQL that will insert the value ‘boyhood’, ‘family’, 2014 into fields Title, Genre, year into the table Film.

Answer 1

Insert into Film (Title, Genre, yeaer) values (‘Boyhood’, ‘family’, 2014)

Question 2

State SQL that will diusplay all fields and records froim film table.

Answer 2

Select * from Film

Question 3

State SQL that will display film titles that start with ‘The’ from film table.

Answer 3

Select Title from Film where Title like ‘The%’

Question 4

State SQL that will display film titles that contains ‘Will’ from film table.

Answer 4

Select Title from Film where Title like ‘%Will%’

Question 5

State SQL that will display the Title and year of films before the year 2000.

Answer 5

Select Title, Year from Film where Year < 2000

Question 6

State SQL that will display the title and year of films starting with ‘The’ that was before the year 2019.

Answer 6

Select Title, Year from Film where Title Like ‘The%’ AND year < 2019.

Question 7

State SQL that will update the record in the film table whose FilmID equals 5.

Answer 7

UPDATE Film
SET Genre=’Comedy’, Year=2017
WHERE FilmID=5

Question 8

State SQL that will Delete all records from the Film table that have a FilmID of 56

Answer 8

DELETE FROM Film

WHERE FilmID=56

Question 9

State SQL that will Removes the Films table from the database

Answer 9

DROP TABLE Films;

Question 10

State the SQL that allows for Selecting from more than one table (using JOIN)

Answer 10

SELECT
FROM
JOIN
ON.=.

EXAMPLE:
SELECT Rentals.RentalDate, Customers.CustomerSurname
FROM Rentals
JOIN Customers ON Rentals.CustomerID=Customers.CustomerID