Developing SQL Statements to Query Existing Data in a Single…

Generate SQL statements to address the problems below using the COVID19_DB database. Each problem must be addressed by a single SQL statement. Use the following database design diagram and data dictionary document as a guide in forming your statements:

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: Display the list of COVID-19 vaccines.

Expected Output:

Problem 2: Display the list of COVID-19 vaccines in alphabetical order by vaccine name.

Expected Output:

Problem 3: Display the COVID-19 vaccines that are suitable for children (minimum age < 18 years).

Expected Output:

Problem 4: Which states/jurisdictions have a population between 10,000,000 and 20,000,000? Show both the state/jurisdiction names and populations in alphabetical order by state/jurisdiction.

Expected Output:

Problem 5: Provide a list of the states/jurisdictions with names starting with the letter M. The output needs to show the state/jurisdiction name, capital, and population in alphabetical order by state/jurisdiction name.

Expected Output:

Problem 6: List the size/area for the following states: Pennsylvania, Iowa, Rhode Island, Maine, and Alabama. Show the state/jurisdiction names and size/area values in descending size/area order.

Expected Output:

Problem 7: Show the COVID-19 vaccine distribution dates for dose allocations that exceeded 600,000 for any of the vaccines. The output needs to show both the vaccine distribution dates and dose allocations. The results must be presented in chronological order (i.e., oldest to most recent).

Expected Output:

Problem 8: List the first and second COVID-19 vaccine dose series volumes for children. Show both the dose series and volume in the output. (Hint: Permissible attribute values for BIT data types are ‘TRUE’ and ‘FALSE’.)

Expected Output:

Problem 9: List the dates the number of reported COVID-19 cases exceeded 75,000 for any state/jurisdiction. Show the calendar date and number of reported COVID-19 cases in chronological order (i.e., oldest to most recent).

Expected Output:

Problem 10: List the COVID-19 vaccine ingredients that are in both the child and adult formulations. Show the ingredients in alphabetical order. (Hint: Permissible attribute values for BIT data types are ‘TRUE’ and ‘FALSE’.)

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