I'm trying create table with sql and it's not working.       CREATE TABLE STATS( US_COVID_DEATHS VARCHAR(50) AGE DOUBLE, GENDER DOUBLE,  RATIO DOUBLE);

Principles of Information Systems (MindTap Course List)
13th Edition
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter14: Ethical, Legal, And Social Issues Of Information Systems
Section: Chapter Questions
Problem 16SAT
icon
Related questions
icon
Concept explainers
Question
I'm trying create table with sql and it's not working.
 
 
 
CREATE TABLE STATS(
US_COVID_DEATHS VARCHAR(50)
AGE DOUBLE,
GENDER DOUBLE, 
RATIO DOUBLE);


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
Transcribed Image Text: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
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
I'm trying to figure out why it's still not working.
 
CREATE TABLE STATS(
Deaths_per_100000 INTEGER(50),
AGE INTEGER(20),
GENDER VARCHAR(10), 
RATIO DOUBLE);

INSERT INTO STATS VALUES (100000, 'Under 44 Years', 'Female', 1)
 
 
Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Query Syntax
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning