Answered step by step
Verified Expert Solution
Link Copied!

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

imageimage

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introductory Statistics Exploring The World Through Data

Authors: Robert Gould, Colleen Ryan

2nd Edition

9780321978509, 321978277, 321978501, 978-0321978271

More Books

Students also viewed these Databases questions