Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Now it is time to write some SQL queries. Run each query on the populated table to display each query. Query 1: Display all
Now it is time to write some SQL queries. Run each query on the populated table to display each query. Query 1: Display all those individuals who are males and are less than 30 years of age. screenshot of your query and the output for the first 25 results only. Include a Query 2: Display all those individuals who are 70 years of age or older and have a Description of Injury as Ingestion (DescriptionofInjury). Include a screenshot of your query and the output for the first 5 results only. Hint: There are many forms of Ingestion in the data, make sure your Description of Injury is solely filtering for 'Ingestion'. Query 3: Display all those individuals who were injured in HARTFORD county (InjuryCounty) in an Automobile, Shed, or Apartment (InjuryPlace). Include a screenshot of your query and the output for all of the results. III = Editor Data Data source AwsDataCatalog Database adrd Tables and views Q Filter tables and views Tables (1) Recent queries 018_csv id date datetype age accidental_drug_related_deaths_2012_2 sex race Saved queries Settings residencecity Create C < < 1 > string string: string : bigint string : string : string : Query 8: 1 |SELECT * FROM "adrd"."accidental_drug_related_deaths_2012_2018_csv" limit 10;| SQL Ln 1, Col 78 Run again Query results Completed Results (0) Q Search rows Explain Query stats Cancel Clear Create Workgroup primary Time in queue: 124 ms Run time: 2.517 sec Copy + Reuse query results *Athena engine version 3 only Data scanned: Download results < 1 >
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started