Now it is time to write some SQL queries. Run each query on the populated table...
Fantastic news! We've Found the answer you've been seeking!
Question:
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 >
Expert Answer:
Related Book For
Introductory Statistics Exploring The World Through Data
ISBN: 9780321978271
2nd Edition
Authors: Robert Gould, Colleen Ryan
Posted Date:
Students also viewed these databases questions
-
Nuk Taku Co uses Job order Costing. The following Cost Apply to the company Operations Direct Materials Used 250,000 Direct Labor 300,000 Indirect Labor 6,000 Rent Factory 60,000 Building Indirect...
-
Create a conclusion to following work. Hotels form an uninterrupted narrative of a story, filling guests with emotions that define their stay. They have ceased to be considered one-dimensional places...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The following matrix is row-equivalent to the augmented matrix of a linear system. Describe the solution set of that system. 1 0 1 5 0000 0013 0000 Find all possible values of a for which the...
-
Explain the possible disadvantages of a machining operation in a discontinuous chip is produced.
-
In a sample of a statistics class, an exam's scores have a mean = 87 and standard deviation = 6. Sarah scored an 85 on her exam. What is the probability that a student received a higher score on the...
-
Partnerships have operating expenses each month. Advertising, depreciation, and rent expense are examples of those operating expenses. Controlling these expenses affects the net income of the...
-
After completing its capital spending for the year, Carlson Manufacturing has $1,000 extra cash. Carlson's managers must choose between investing the cash in Treasury bonds that yield 8 percent or...
-
IFT 366 TCP/IP & Routing Lab 34 Extended ACL III - Telnet Objective Configure an extended ACL on a network topology 1. Setup up the following topology on Packet Tracer Se2/0 Fa0/01 Fa0/2...
-
Ellipses Corp is a small business that operates in Herndon, VA. The company is located at10 Period Lane, Herndon, VA 20170. Its federal Employer Identification Number is 77-7777777, and its...
-
Find the optimal bundle for the following utility functions and for budget line (P1X1+P2X2=m) a) U(X1,X2)=X1X2 b) U(X1,X2)=X1^2X2^3 c) U(X1,X2)=X1^2+2X2 d)U(X1,X2)= ln (x1^3X2^4) e) U(X1,X2)= 2X1+X2...
-
List the individual financial statements normally included in a complete set and indicate which phrase of the opinion paragraph applies to each statement.
-
Ages of dogs at a rescue facility. In Exercises 714, determine whether the data are qualitative or quantitative. Explain your reasoning.
-
Which of the following is true of audit sampling? a. A sample is less time-consuming and provides less assurance than examining all items in the population. b. A sample is less time-consuming and...
-
Which of the following best illustrates an error caused by sampling? a. A randomly chosen sample may not be representative of the population as a whole on the characteristic of interest. b. An...
-
A CPA s audit report on a client s balance sheet, income statement, and statement of cash flows was sent to the stockholders. The client now wishes to present only the balance sheet along with an...
-
If the model were to incorporate AI tools such as ChatGPT, how might it be changed? I'm asking because it seems that AI tools will really make tasks easier, including how to use the technology. Your...
-
Stephen Schor, an accountant in New York City, advised his client, Andre Romanelli, Inc., to open an account at J. P. Morgan Chase Bank, N.A., to obtain a favorable interest rate on a line of credit....
-
The ten top-grossing DreamWorks animated movies for the U.S. box office up to July 2013 are shown in the table, in millions of dollars. Movie $Millions Shrek 2 ............441 Shrek the Third...
-
The null hypothesis on true/false tests is that the student is guessing, and the proportion of right answers is 0.50. A student taking a five-question true/false quiz gets 4 right out of 5. She says...
-
Roll a fair six-sided die. a. What is the probability that the die shows an odd number OR a number less than 3 on top? b. What is the probability that the die shows an odd number OR a number less...
-
Use the Peclet number [Eq. (16-111a)] to determine which model (completely mixed or plug flow) is appropriate for the distillation column calculation at \(\mathrm{x}_{\mathrm{W}}=0.48\) in Problems...
-
The value of \(\mathrm{E}_{\mathrm{MD}}=0.927\) in Example 16-5 is lower than the 0.95 value your supervisor expects. You are tasked to see if the current mixer with the current feed rate can be...
-
Which activity is part of the sales order entry process? a. setting customer credit limits b. preparing a bill of lading c. checking customer credit d. approving sales returns
Study smarter with the SolutionInn App