Questlon - 4: For each department relrieve the department number, number of employees and their average salary.Question-5: For each project, retrieve the project name, number of employees from department number 4 who work on the projectQuestion -6-Retrieve the first name, last name, project location of all every employee who wotks on project 2

by bartleby guidelines i am able to do only first question.

Question - 4 For each department retrieve the department number, number of employees and their average salary Question-5: For each project, retrieve the project name, number of employces from department number 4 who work on the project. Question -6 -Retrieve the first name, last name, project location of all every employee who wotks on project Z

Question - 4 For each department retrieve the department number, number of employees and their average salary Question-5: For each project, retrieve the project name, number of employces from department number 4 who work on the project. Question -6 -Retrieve the first name, last name, project location of all every employee who wotks on project Z

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Create a procedure to display manager ID and number of employees managed by each manager. Use Employees table on SQL server?
You will be using the Colonial Adventure Tours database. How many current reservations does Colonial Adventure Tours have and what is the total number of persons for all reservations?
Display manager ID and number of employees managed bythe manager. using sql plus hr user
Create a report of employees within the Research department showing First Name, Last Name, sorted alphabetically A-Z.
write the following queries (n) Identify flats with at least three rooms and with a monthly rent no higher than £500 in Aberdeen. (0) List the details of leases due to expire next month at a given branch. (p) List the total number of leases with rental periods that are less than one year at branches in London. (q) List the total possible daily rental for property at each branch, ordered by branch number. System Description: Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manages the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly…
Display the territory ID and the number of salespersons in the territory for all territories that have more than one salesperson. Label the number of salespersons NumSalesPersons
Select all managers whose firstname starts with letter M and department they lead have less than 10 employees. Present manager and employee count in the result set. Order result set by employee count in descending order.
Thank you for helping! Write the SQL code to produce the total number of hours and charges for each of the projects represented in the ASSIGNMENT table. The result is shown as below. Write the SQL code to display the information of employees who are working as either programmer or system analyst. Write the SQL code to produce job_descriptions(job_title) of employees who are working at project ‘Evergreen’.
Create a report of departments and their number of current employees, ordered from high to low. Note: The to_date column can be used to select currently working employees. Please make a nice report showing department name
C. Write the following queries to retrieve the information detailed below. Average number of borrowed books by job title Create a VIEW and display the titles that were borrowed by at least 20% of clients The top month of borrows in 2017 Average number of borrows by age The oldest and the youngest clients of the library First and last names of authors that wrote books in more than one genre
Create a query of renters not qualified to rent, list who rented boat unique ID, Renter name, Renter Telephone Number and Renter Email address. Create a query where you can see all boats available for rent that are longer than 30 feet, include Boat Unique Identifier, Boat Type, Boat Length, Price of Rental Per Day and Location (where boat is parked for pickup). Create a query where you can see all powerboats available for rent of any length include Boat Unique Identifier, Boat Type, Boat Length, Price of Rental Per Day and Location. Create a query where you can see all the boats available at a Marina Name = ‘Star Island Yacht Club’ or a name of a marina in your data. Include Boat Name, BoatT ype and Cost to rent the boat per day. Create a query where you can see all boats available at a Marina Name = “Star Island Yacht Club”, include Boat Name, Boat Type and Cost to Rent per Day for only boats that have a Cost to Rent per Day that is more than $400. Create an update query that…
List the name of employee who is working on a project with the budget that is below this project's divisional average project budget (use correlated subquery).