Logo
Home Study Material Contact Search
AI Chat FREE
  1. computer science
  2. programming
  3. sql only- given tables- employee (employeeid, firs

SQL ONLY- Given Tables- Employee (EmployeeID, FirstName, LastName, Address) Department (DeptNo, DepartmentName, City) DepartmentEmployee(DeptNo, EmployeeID, Position) Project (ProjectNo, ProjectName, DeptNo) Project Team (...

50.1K

Verified Solution

Question

Programming

SQL ONLY-

Given Tables-

Employee (EmployeeID, FirstName, LastName,Address)

Department (DeptNo, DepartmentName, City)

DepartmentEmployee(DeptNo, EmployeeID,Position)

Project (ProjectNo, ProjectName, DeptNo)

Project Team ( ProjectNo, EmployeeID, Role)

MAKE THE QUERY FOR-

1. List the name and position of all the employee who works inthe (DeptNo = ‘22C’).

2. List the total number of employees in each department forthose departments with more than 5 employees.

3. List the project number, project name and the number ofemployees who worked on each project role.

Answer & Explanation Solved by verified expert
4.1 Ratings (863 Votes)
Answer 1Select eFirstNameeLastNamedePosition from Employee e join DepartmentEmployee de on deEmployeeID eEmploeeID where deDeptNo 22C order by eFirstName This query will    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Explanation of a \"non-contractual promise.\" 10.0 pts This criterion is linked to a Learning Outcome Example of...

Operations Management
Q

The following information is to be used for the next two questions. Molar absorptivity data for...

Chemistry
Q

A damped oscillator is formed by attaching a mass with m = 1.5 kg to one...

Physics
Q

29 26 As shown in Fig below P and Q are two coaxial conducting loops...

Physics
Q

In the diagram the circle will be dilated by a scale factor of 3 about...

Geometry
Q

A person has $1,587 in your bank account that is paying an interest rate of...

Basic Math
Q

Solve log4 x log x 6 2 for x Select all that apply 0 x...

Basic Math
Q

Case #1 - Airbnb - Due Sep 16, 2021 11:00 AM...

Accounting
Q

Sandy and John Ferguson got married eight years ago and have a seven-year-old daughter, Samantha....

Accounting
Q

Suppose the comparative balance sheets of Nike, Inc. are presented here. 2019 Nike, Inc. Comparative...

Accounting
Q

Assume the following information for a merchandising company. What is the amount of fixed administrative...

Accounting
Q

Two stock prices for six days are given below. Price A Price B 62 80...

Finance