Part D:
Data Retrieval (15%) The following queries are to be supported. Each one of the queries below must be one SQL statement. It is fine to use several nested queries, link several SELECT statements with various operators etc. However, it is not acceptable to have multiple and separated queries for each task. The expected outcome of completing this task is as follows. 1. One SQL script file named Queries.sql containing all the queries developed for the tasks in this section. It is important that you add comment lines to separate the queries and indicate which task they belong to. Note that valid SQL comments must not generate errors in SQLite Studio. The marker of your work will use this file to execute and test your queries.
Task D.1
For a given country (e.g., Afghanistan), list the total number of vaccines administered in each observation date recorded in the dataset.
Task D.2
Produces a result set containing cumulative number of COVID-19 doses administered by each country. That is, the name of each country and the cumulative number of doses administered in that country.
Task D.3
Produce a list of all countries with the type of vaccines (e.g., Oxford/AstraZeneca, Pfizer/BioNTech) administered in each country. For a country that has administered several types of vaccine, the result set is required to show several tuples reporting each type of vaccine in a separate tuple.
Task D.4
There are different sources of data used to produce the data set. Produce a report showing the total number of vaccines administered according to each data source.
Task D.5
How does various countries compare in the speed of their vaccine administration? Produce a report that lists all the observation dates and, for each date, list the total number of people fully vaccinated in each one of the 4 countries used in this assignment.
[Date, Australia, United States, France, Israel]
