Question 1

• Write a SQL query to list country names that start with I and with a timezone>3, from the database of countries.sqlite.

Question 2

• Write a SQL query to count how many countries whose name start with I and with a timezone>3, from the database countries.sqlite.

Question 3

• Write a SQL query to get the following output. Hint: please refer to the SQL query in the video at 23:00, https://youtu.be/0hKmmh_4t7w

Item	Price	Quantity	Total
Candy	1.2	5	6.0
Candy	1.2	2	2.4
Candy	1.2	3	3.6
Drinks	1	1	1
Fruit	0.8	2	1.6
Fruit	0.8	4	3.2
Snacks	0.8	3	2.4
Snacks	0.8	2	1.6

Question 4

• Write a SQL query to get the following output, sorted by Total from the biggest to smallest number. Hint: please refer to the SQL query in the video at 24:40, https://youtu.be/0hKmmh_4t7w

Item	Price	Quantity	Total
Candy	1.2	10	12.0
Fruit	0.8	6	4.8
Snacks	0.8	5	4.0
Drinks	1	1	1