1.3.2D SQL

Question 1

Write a SQL command to select all the columns from the “celebs” table.

Answer 1

SELECT * FROM celebs;

Question 2

What type of programming language is SQL?

Answer 2

Declarative.

Question 3

What type of programming language is SQL?

Answer 3

Declarative

Question 4

Write a SQL command to select all the columns from the “celebs” table.

Answer 4

SELECT * FROM celebs;

Question 5

Write a SQL command to insert the following data into the table “celebs”

Data:
1
Justin Bieber
21

Columns:
ID
Name
Age

Answer 5

INSERT INTO celebs ([ID], [Name], [Age]) VALUES (1, ‘Justin Bieber’, 21);

Question 6

Write a SQL command to update the following data in the table “celebs”

Data:
1
Justin Bieber
21

Columns:
ID
Name
Age

Update age to 22.

Answer 6

UPDATE celebs
SET age = 22
WHERE id = 1;

Question 7

Write a SQL command to update the following data in the table “celebs”

Data:
1
Justin Bieber
21

Columns:
ID
Name
Age

Update age to 22.

Answer 7

UPDATE celebs
SET age = 22
WHERE id = 1;

Question 8

Write a SQL command to add a new column called “Twitter Handle” in the table named “celebs”, with the field type as text.

Answer 8

ALTER TABLE celebs ADD COLUMN [Twitter Handle] TEXT;

Question 9

Write a SQL command to retrieve the columns “Name” and “IMDB Rating” in the table named “Movies”.

Answer 9

SELECT [Name], [IMDB_Rating] FROM [Movies];

Question 10

Write a SQL command to retrieve the columns “Name” and IMDB Rating in the table named “Movies”.

Answer 10

SELECT [Name], [IMDB_Rating] FROM [Movies];

Question 11

Write a SQL command to only retrieve unique values from the “Genre” column in the table named “Movies”.

Answer 11

SELECT DISTINCT [Genre] FROM [Movies];

Question 12

Write a SQL command to retrieve movies where the “IMDB Rating” is greater than 8 in the table named “Movies”.

Answer 12

SELECT * FROM [Movies] WHERE [IMDB_Rating] > 8;

Question 13

Write a SQL command to retrieve movie names (Name) where the movie name is like “Se*en”, where * represents any character, in the table named “Movies”.

Answer 13

SELECT * FROM [Movies] WHERE [Name] LIKE ‘Se_en’;

Question 14

Write a SQL command to retrieve movie names (Name) where the movie name starts with “A”, in the table named “Movies”.

Answer 14

SELECT * FROM [Movies] WHERE [Name] LIKE ‘A%’;

Question 15

Write a SQL command to retrieve movie names (Name) where the movie name ends with “a”, in the table named “Movies”.

Answer 15

SELECT * FROM [Movies] WHERE [Name] LIKE ‘%a’;

Question 16

Write a SQL command to retrieve movie names (Name) where the movie name contains “man”, in the table named “Movies”.

Answer 16

SELECT * FROM [Movies] WHERE [Name] LIKE ‘%man%’;

Question 17

Write a SQL command to retrieve movie names (Name) where the movie name starting letter is between A and J, in the table named “Movies”;

Answer 17

SELECT * FROM [Movies] WHERE [Name] BETWEEN ‘A’ AND ‘J’;

Question 18

Write a SQL command to retrieve movie names “Name” where the movie name starting letter is between A and J, in the table named “Movies”;

Answer 18

SELECT * FROM [Movies] WHERE [Name] BETWEEN ‘A’ AND ‘J’;

Question 19

Does this SQL command retrieve movie names that start with J?

SELECT * FROM [Movies] WHERE [Name] BETWEEN ‘A’ AND ‘J’;

Answer 19

No.

Question 20

Write a SQL command to retrieve movies where the year (Year) is between 1990 and 2000.

Answer 20

SELECT * FROM [Movies] WHERE [Year] BETWEEN 1990 AND 2000;

Question 21

Write a SQL command to retrieve movies where the year “Year” is between 1990 and 2000.

Answer 21

SELECT * FROM [Movies] WHERE [Year] BETWEEN 1990 AND 2000;

Question 22

Does this SQL command retrieve movies that were released in the year 2000?

SELECT * FROM [Movies] WHERE [Year] BETWEEN 1990 AND 2000;

Answer 22

Yes.

Question 23

Write a SQL command to retrieve movies that were released between the year (Year) 1990 and 2000 and also where the genre (Genre) is comedy, in the table named “Movies”.

Answer 23

SELECT * FROM [Movies]
WHERE [Year] BETWEEN 1990 and 2000
AND [Genre] = ‘comedy’;

Question 24

Write a SQL command to retrieve movies where the genre (Genre) is comedy or if the movie was released after the year (Year) 1980, in the table named “Movies”.

Answer 24

SELECT * FROM [Movies]
WHERE [Genre] = ‘comedy’
OR [Year] < 1980;

Question 25

Write a SQL command to order the movies in descending order based on the IMDB Rating (IMDB Rating), in the table named “Movies”.

Answer 25

SELECT * FROM [Movies] ORDER BY [IMDB Rating) DESC;

Question 26

Write a SQL command to order the movies in ascending order based on the IMDB Rating (IMDB Rating), in the table named “Movies”.

Answer 26

SELECT * FROM [Movies] ORDER BY [IMDB Rating) ASC;

Question 27

Write a SQL command to return the lowest 3 rated films (IMDB Rating) in the table named “Movies”.

Answer 27

SELECT * FROM [Movies]
ORDER BY [IMDB Rating] ASC
LIMIT 3;