Answer the query using SQL.For each department which has more than 5 female employees, retrieve the department name, thenumber of female employees in the department, and their average salary. EMPLOYEEENAMEMINITLNAMESSNBDATEADDRESSSEXSALARYSUPERSSNDNODEPARTMENTDNAMEDNUMBERMGRSSNMGRSTARTDATEDEPT LOCATIONSDNUMBERDLOCATIONPROJECTPNAMEPNUMBERPLOCATIONDNUMWORKS_ONESSNPNOHOURSDEPENDENTESSNDEPENDENT_NAMESEXBDATERELATIONSHIP

In the following Query we will retrieve three things: The department name The number of female employees And their average salarySelect dname,count(dno),Avg(salary) From department d ,employee e Where d.dnumber=e.dnoAnd sex=‘Female’ //if not worked try "F" instead of "Female".And count(dno)>5;

Answered: Answer the query using SQL. For each…

Engineering

Computer Science

Answer the query using SQL. For each department which has more than 5 female employees, retrieve the department name, the number of female employees in the department, and their average salary.

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

List the movie titles and the names of their production companies. Only include production companies that have movies. Sort alphabetically by the movie title. use sql ( so theres a table of movie and a table of production)
List the names of all customers that have a credit limit of $7,500 or less
SQL query using Rank() Retrieve the top-selling product of each day.Use the total sold quantity to determine the top-selling product.The top-selling product has the highest total sold quantity.If there is a tie, the solution must pick up the tie.Include the order date, product id, and the total sold quantity of the top-selling product of each day in the returned data.Sort the returned data by the order date.*/
Show the employees who were in the engineering department as of Jan. 1, 2005 (using SQL)
Please help: Using the following sql file, how would you find List all the rows in which the prescription dates occur on or after November 14. How many doctors provide prescriptions with 30 tablets in total? List doctor’s details where speciality is either Dermatology or Neurology. (Use INoperator). List the results by the first name in ascending order and the last name indescending order Find all patients rows whose first names include ‘George’ (Assume case sensitivity). List number of patients that do not have a phone number. Beginfor c in (select table_name from user_tables) loopexecute immediate ('drop table '||c.table_name||' cascade constraints');end loop;End; //* Assignment_1 */ ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY';CREATE TABLE DOCTOR (DOC_ID varchar2(5) PRIMARY KEY,DOC_LNAME varchar2(15),DOC_FNAME varchar2(15),DOC_INITIAL varchar2(1),DOC_SPECIALTY varchar2(15));INSERT INTO DOCTOR…
List all vendors with their address(city, state,zipcode) for all the vendors who have credited account (credit total>0)) Hint:Vendors & Invoices tables with credit total column WHERE vendors.vendor id = invoices.vendor id AND CREDIT_TOTAL>0; %3D
Write a query to determine how many products you can find in the Production.Product table. This is an SQL Table.
using SQL: Find the pub_id of the publisher(s) that have published the LEAST expensive book
Using SQL: List the title_name and book type of books that have the lowest royalty rate.
Write the SQL code that will produce the results shown as below. Write the SQL code to calculate the ASSIGN_CHARGE values in the ASSIGNMENT table. Note that ASSIGN_CHARGE is a derived attribute that is calculated by multiplying ASSIGN_CHG_HR by ASSIGN_HOURS. Write the SQL code that will yield the total number of hours worked for each employee and the total charges stemming from those hours worked. The result is shown as below.
Create a query to show the Technician Number, Last Name, First Name, Client Number,and Client Name for clients whose technician number is 23 (use Boolean variables).Save your query
Use SQL and TAL Distributors database to complete the following questions:List the customer number and name for all customers located in the city of Grove. Your query should ignore case. For example, a customer with the city Grove should be included as should customers whose city is GROVE, grove, GrOvE, and so on.