Generate Multi-Table Query Statements to Address Health-Rela…

Assignment Instructions

You must incorporate confirmatory work screenshots into a Microsoft Word assignment document (or equivalent). The following image illustrates an example problem screenshot showing both the SQL statement and confirmatory execution results:

Problem 1: List the active ingredients for each of the vaccines. Show the full vaccine name in the query output in alphabetical order. (Hint: The IngredientType attribute denotes whether an ingredient is active or inactive.)

Expected Output:

Problem 2: List the states/jurisdictions and reported COVID deaths on October 31, 2020 for states/jurisdictions with a population exceeding 10,000,000. The output needs to show the full state/jurisdiction names (not the abbreviations).

Expected Output:

Problem 3: Which states/jurisdictions had one or more reported COVID cases on February 29, 2020? Show the full state/jurisdiction names and number of reported COVID cases in the query output. Show the output in alphabetical order by full state/jurisdiction name (not the abbreviations).

Expected Output:

Problem 4: Show the calendar dates and reported daily COVID-19 deaths exceeding 100 for New York and California in the month of March 2020. Display the full state/jurisdiction names in the query output. Present the query results in chronological order (i.e., oldest to latest calendar dates).

Expected Output:

Problem 5: List the average daily reported COVID case values for Georgia, Florida, and Alabama for the time period between December 1, 2020 and December 31, 2020. Present the full state name and average values in the query output. Group the results by full state name in alphabetical order.

Expected Output:

Problem 6: List the full vaccine and state/jurisdiction names for vaccines administered on December 30, 2020. Show the reported number of doses administered in the query output. Sort the output in alphabetical order by full vaccine name and then by full state/jurisdiction name.

Expected Output:

Problem 7: Show the total reported COVID-19 cases exceeding 2,000,000 per state/jurisdiction in the 2021 calendar year. Display the full state/jurisdiction names in the query output. Group the results by full state/jurisdiction name. Present the results in alphabetical order by full state/jurisdiction name. (Hint: GROUP BY and HAVING clauses are required for this query.)

Expected Output:

Problem 8: Show the full vaccine names and dose volumes for the adult second dose series. Display the results in alphabetical order by full vaccine name. (Hint: Permissible attribute values for BIT data types are ‘TRUE’ and ‘FALSE’.)

Expected Output:

Problem 9: Show the full vaccine names and dose volumes for the adult second dose series. Display the results in alphabetical order by full vaccine name. (Hint: Permissible attribute values for BIT data types are ‘TRUE’ and ‘FALSE’.)

Expected Output:

Problem 10: Estimate the number of reported COVID-19 cases per 1,000 people in 2021 for Florida, New York, California, Texas, and Michigan. Group and sort the results by full state/jurisdiction name in alphabetical order. The calculation is performed via the following equation:

COVID-19 Cases/1,000 people = SUM(Daily Reported COVID-19 Cases * 1000 / Population)

Expected Output:

Struggling with your essay and deadlines?

Get this or a similar paper done in as fast as 4 hours, 24/7.

NB: We do not sell prewritten papers. All essays are written from scratch according to specific needs and instructions

✔Secure Service ✔ Plagiarism Free ✔On-time Delivery

WRITE MY PAPER