Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started