Database Schema:

Locations(LocationID, CountryName, VaccineType) Vaccination_by_manufacturer(ManufacturerID, Covishield, Covaxin) Vaccination_by_age_group(AgeGroupID, 8to18Years, 19to35Years, 36to55Years, 55Above) US_state_vaccination(USSVID, District, State) Country_by_Country_data(CountrybyCountryID, Australia, UnitedStates, France, Israel) Australia(AustraliaID, DailyObservation) UnitedStates(UnitedStatesID, DailyObservation) France(FranceID, DailyObservation) Israel(IsraelID, DailyObservation)

The following queries are to be supported. Each one of the queries below must be one SQL statement. It is acceptable to use several nested queries, combine 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 against your database.1.A PDF file named QueryResults.pdf containing the query for each of the following tasks together with a snapshot of the first 10 results of your query. The snapshot must also show the total number of results retrieved by the query. A sample snapshot is provided below for your reference. 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 from the first observation until the end of June 2021. For the example of Afghanistan, each column in the expected result set will have the following structure. 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. Each column in the expected result set will have the following structure.

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. Order the result set by the total number of administered vaccines.

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.

K 1 1 1 Total rows loaded: 21 language 1 Khoekhoe 2 Ndebele 3 San 4 Shona 5 Tswana 6 Afrikaans 7 English 8 Northsotho 9 Southsotho 10 Swazi Tronca Figure 1: Sample results snapshot with total rows Country Observation Date Administered Vaccine Figure 2: Column Headers in the Result Set for Task D.1 Country Cumulative Doses Figure 3: Column Headers in the Result Set for Task D.2 Country Vaccine Type Figure 4: Column Headers in the Result Set for Task D.3 Source Name Total Administered Vaccines Source URL Figure 5: Column Headers in the Result Set for Task D.4 Date Israel Australia United States France Figure 6: Column Headers in the Result Set for Task D.5