Database SQL query

profileBryanAdams

Consider the employee database of Figure CompanyDB:

*************************************************

* employee (employee_name, street, city) *

* works (employee_name, company_name, salary) *

* company (company_name, city) *

* manages (employee_name, manager_name) *

*************************************************

Using the course database, give an expression in SQL for each of the 

following queries. 

The DB or the (.SQL) files are attached, upload them, and read the .docx file to answer each question. The expected result from each question is provided with each question. I want you to just write SQL expressions and see if you get the same results as provided. Add those SQL queries to the .docx file and give it back to me.

  • 9 years ago
  • 5
Answer(1)

Purchase the answer to view it

blurred-text
  • attachment
    cmsi_486_201430_sql_workshop_companydb_qs2_1_solution.docx
  • attachment
    cmsi_486_201430_sql_workshop_companydb_qs2_1_solution_plus.docx
  • attachment
    company.zip
Bids(0)