Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Complete and full answer in order to get credit .Thank u The SQL s tatements comprising the DDL for the COMPANY Database (employee,department,project,dependent,etc...). Remember..just SQL

Complete and full answer in order to get credit .Thank u

The SQL statements comprising the DDL for the COMPANY Database (employee,department,project,dependent,etc...). Remember..just SQL

1. Retrieve the name of each employee that works in the Research department. You are allowed to use only 1 table in any FROM clause.

2. List the ssn and the name of each employee that either works in department 5 or has a salary greater or equal to $35,000. You are allowed to use only one condition term in any WHERE clause; i.e., don't use AND/OR Boolean operations.

3. List the social security number of each employee that works on at least one of the projects 1, 2, and 3. You are allowed to use only one condition term in any WHERE clause.

4. Retrieve the names of all employees of the Research department who work more than 10 hours per week on the ProductX project.

5. Retrieve the names of all employees who work on all projects [every project] located in either Bellaire or Sugarland. That is, if p1, p2, and p3 are located in Bellaire; and p4 and p5 are located in Sugarland; then I want an employee who works on p1, p2, p3, p4, and p5.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

Finding and scheduling appointments with new prospective clients.

Answered: 1 week ago