Company database.

business

Description

This assignment tests your ability to query a database to find the answers to four questions. You will use the Company database, but your assignment is NOT to find the answers to the four questions, but rather to identify the queries necessary to find the answers. You should NOT enter the answers to the questions, rather enter the SQL query you would use to determine the answer. Before completing, please verify the accuracy of your queries using a Linux environment.

Queries:

1. How many employees work in the Research department? (Your query should report one number for each project.)

2. What is the total number of hours worked on each project by project name? (Your query should report one number for each project.)

3. Which employees are supervisors? (List first, middle initial, and last name. You may not hardcode the SSN in your query, and the query must print each name only once.)

Database Link:

https://thegnudist.github.io/accounting-architecture/supplement/data-analytics/company.sql           

Instruction Files

Related Questions in business category