I get confused on making a graph out of a sql table.I wasn't what I did wrong.REATE TABLE STATS(U.S_Covid_deaths_by_age_and_gender_:Ratios char(50), VALUE INT);INSERT INTO STATS VALUES ('Female', 'Under 44 years', 1); ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.S_Covid_deaths_by_age_and_gender_:Ratios char(50), VALUE INT)' at line 1 ## Gender Disparity in Covid-19 Death RatesThis gender gap can be seen more clearly in the ratio of the death rates of men and women within age brackets:### U.S. Covid Deaths by Age and Gender: Ratios![Graph Image](link to the graph)#### Description of the Graph:The bar graph titled "U.S. Covid deaths by age and gender: Ratios" illustrates the ratio of Covid-19 death rates between men and women across different age brackets. - The X-axis represents the different age brackets: - Under 44 years - 45-54 years - 55-64 years - 65-74 years - 75-84 years - 85+ years- The Y-axis represents the ratio of death rates, ranging from 0 to 3.Two distinct sets of bars are presented for each age bracket:- Grey Bars: Female to Female ratios (used as a reference point of 1 across all age brackets).- Blue Bars: Male to Female ratios. **Key Observations:**- For age brackets `Under 44 years`, `45-54 years`, `55-64 years`, `65-74 years`, `75-84 years`, and `85+ years`, the Male to Female ratio is consistently higher, signifying that men have a higher death rate compared to women.- The highest disparity is observed in the `45-54 years` bracket, with the Male to Female ratio peaking close to 2.5.- As the age increases beyond `75-84 years`, the ratio begins to slightly decrease but remains higher compared to the earlier age bracket.**Source:**The data is sourced from the CDC NCHS, accessed on 5/11/20 for the period from 2/1/2020 to 5/2/2020.

Gender equality is when people of all genders have liberty, fair treatment, responsibilities and…

Answered: syntax to

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

I get confused on making a graph out of a sql table.

I wasn't what I did wrong.

REATE TABLE STATS(U.S_Covid_deaths_by_age_and_gender_:Ratios char(50), VALUE INT);

INSERT INTO STATS VALUES ('Female', 'Under 44 years', 1);

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.S_Covid_deaths_by_age_and_gender_:Ratios char(50), VALUE INT)' at line 1

## Gender Disparity in Covid-19 Death Rates

This gender gap can be seen more clearly in the ratio of the death rates of men and women within age brackets:

### U.S. Covid Deaths by Age and Gender: Ratios

![Graph Image](link to the graph)

#### Description of the Graph:

The bar graph titled "U.S. Covid deaths by age and gender: Ratios" illustrates the ratio of Covid-19 death rates between men and women across different age brackets.

- The X-axis represents the different age brackets:
- Under 44 years
- 45-54 years
- 55-64 years
- 65-74 years
- 75-84 years
- 85+ years

- The Y-axis represents the ratio of death rates, ranging from 0 to 3.

Two distinct sets of bars are presented for each age bracket:
- Grey Bars: Female to Female ratios (used as a reference point of 1 across all age brackets).
- Blue Bars: Male to Female ratios.

**Key Observations:**
- For age brackets `Under 44 years`, `45-54 years`, `55-64 years`, `65-74 years`, `75-84 years`, and `85+ years`, the Male to Female ratio is consistently higher, signifying that men have a higher death rate compared to women.
- The highest disparity is observed in the `45-54 years` bracket, with the Male to Female ratio peaking close to 2.5.
- As the age increases beyond `75-84 years`, the ratio begins to slightly decrease but remains higher compared to the earlier age bracket.

**Source:**
The data is sourced from the CDC NCHS, accessed on 5/11/20 for the period from 2/1/2020 to 5/2/2020.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

I needed help on how to create a table for SQL.

CREATE TABLE STATS(U.S_Covid_deaths_by_age_and_gender_:Ratios char(50), VALUE INT);

INSERT INTO STATS VALUES ('Female', 'Under 44 years', 1);

This gender gap can be seen more clearly in the ratio of the death rates of
men and women within age brackets:
U.S. Covid deaths by age and gender: Ratios
2.5
2
1.5
55-64 years 65-74 years
Female:Female Male:Female
0.5
Under 44 years
45-54 years
Source: CDC NCHS, accessed 5/11/20 for 2/1/2020 to 5/2/2020.
75-84 years
85+ years

Solution

by Bartleby Expert

SEE SOLUTION

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions