Now it is time to write some SQL queries. Run each query on the populated table...

Transcribed Image Text:

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 > 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 >