Question: The second part you will create queries to answer the questions below. please use the ERD diagram to answer the questions. 1 . Retrieve all

The second part you will create queries to answer the questions below. please use the ERD diagram to answer the questions.
1.Retrieve all columns from the Age Table
2. How many surveyed were older than 25?
3. How many people were surveyed by Gender?
4. How many times NA appears in the self employed column?
5. How many males participated in the survey received treatment?
6. Write a query to return survey details from males that do remote work from United States that participated in the survey?
7. How many females from Canada have a family history of mental health?
8. How many Females over the age of 40, worked at tech companies and had mental issues interfering their work often?
9. Create a view that contains all survey details from participants that are 30 years-old and younger.
10. How many people have seeked help with anonymity?
age groups =25; 26 to 49, and >50
The second part you will create queries to answer the questions

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Trying to create a database for something like a small restaurant. If possible please attach a picture of an Entity relationship diagram Part A. Database Creation Design and create a relational...

Q:

Design and create a relational database containing information on a collection of items, field of study, hobby, or special interest you may have. Before you start implementing the project you have to...

Q:

ISDS 3110: Data and Information Management LAB 4: Joining Tables SQL Queries In this lab, you will be querying the text schema on the MySQL server. The required tables are person and car. One person...

Q:

Paragraph Styles Cheddy Project Description and Requirements Zchedar Cheddr Background Mr. Z (real name Josh Zubkoff) runs a successful chain of cheese and wine shops in Oregon that specialize in...

Q:

This case provides you data related to XYZ corporation. XYZ is a high-tech company located in the British Columbia and providing services in developing software products, implementation and...

Q:

- - this statement will prevent messages of " ( 1 row ( s ) affected ) " SET NOCOUNT ON - - = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =...

Q:

- - this statement will prevent messages of " ( 1 row ( s ) affected ) " SET NOCOUNT ON - - = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =...

Q:

Paragraph Styles Z CHEDOR Project Fall 2019 Also, prepare a corresponding data listing' for the prototype database. Identify where different fields/attribute names provide the same information and...

Q:

Second, students will interface with another database for the Northwind Company. Students will be responsible for investigating this database and answering questions below on pages 3-5 about:...

Q:

The sweatshop scandal of the 1990s, which revealed that Nike used forced child labor to manufacture its products, greatly damaged the company. Nike has ever since been plagued with the claims of...

Q:

Assume that you are an ambitious, nonfamily manager in a family firm and that one of your peers is the son or daughter of the founder. What, if anything, would keep you interested in pursuing a...

Q:

A D-aldopentose is oxidized by nitric acid to an optically active aldaric acid. A Ruff degradation of the aldopentose leads to a monosaccharide that is oxidized by nitric acid to an optically...

Q:

What program allows parents to save for a child's education? 529 plan 435 plan 999 plan 789 plan

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

Economist John Taylor has suggested that the Fed use the following rule for choosing its target for the federal funds interest rate (r): r = 2% + + 12 (y y*) / y* + 12 ( *), where is the average...

Q:

Suppose banks install automatic teller machines on every block and, by making cash readily available, reduce the amount of money people want to hold. a. Assume the Fed does not change the money...

Q:

Consider two policiesa tax cut that will last for only 1 year and a tax cut that is expected to be permanent. Which policy will stimulate greater spending by consumers? Which policy will have the...