Find top 2 largest departments in terms of number of employees The image contains a table with the following columns and rows:### Columns:1. **EMPNO**: Employee Number2. **ENAME**: Employee Name3. **JOB**: Job Title4. **MGR**: Manager's Employee Number5. **HIREDATE**: Date of Hire6. **SAL**: Salary7. **COMM**: Commission8. **DEPTNO**: Department Number### Row 1:- **EMPNO**: 7839- **ENAME**: KING- **JOB**: PRESIDENT- **MGR**: (null)- **HIREDATE**: 17-NOV-81- **SAL**: 5000- **COMM**: (null)- **DEPTNO**: 10### Row 2:- **EMPNO**: 7566- **ENAME**: JONES- **JOB**: MANAGER- **MGR**: 7839- **HIREDATE**: 02-APR-81- **SAL**: 2975- **COMM**: (null)- **DEPTNO**: 20This table provides data about employees, including their ID, name, position, manager, hire date, salary, commission (if any), and department number. The image is a table displaying information about different departments in a company. The table consists of three columns:1. **DEPTNO** - Department Number2. **DNAME** - Department Name3. **LOC** - LocationThe rows of the table list the specific details for each department:- **Row 1:** - DEPTNO: 10 - DNAME: ACCOUNTING - LOC: NEW YORK- **Row 2:** - DEPTNO: 20 - DNAME: RESEARCH - LOC: DALLAS- **Row 3:** - DEPTNO: 30 - DNAME: SALES - LOC: CHICAGO- **Row 4:** - DEPTNO: 40 - DNAME: OPERATIONS - LOC: BOSTONThis table can be used to understand the organizational structure by department number, department name, and their respective locations.

The given two tables record the data about EMPLOYEES and DEPARTMENTS. An Employee has one…

Answered: Find top 2 largest departments in terms…

Engineering

Computer Science

Find top 2 largest departments in terms of number of employees

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

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.*/
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.
Find the number of staff for each city. Find the staff name who has the minimum salary for each city.
Some rows of the table STUDENT are shown below: CODE NAME DEPARTMENT GPA YEAR 291 ALEX PSI 3.1 1992 938 MICHELE PHY 2.3 1992 931 JHON MD 3.3 2001 182 JOE MD 3.4 2002 190 REY PHY 2.0 2001 330 RON PSI 3.9 2001 You want the name all departments that have a department GPA average of 2004 greater than the global GPA average. Which query gives you the desired result? a. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT); b. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 AND AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT) GROUP BY DEPARTMENT; c. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT GPA FROM STUDENT GROUP BY DEPARTMENT); d. SELECT * FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT);
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?
Calculate the "Days on Market" in column L by finding the difference between Date Sold icokumn and Date Listed (column H) first. What is the average Sales Price for all the properties with 2or more bedrooms and more than 180 days on the market?
For each customer who has a post-paid service, show how many of these customers have opted to have their bills emailed compared to those who have theirs by postal mail. Name this query Q3- PPBills.
1. List the book title and retail price for all books with a retail price lower than the averageretail price of all books sold by JustLee Books.
List the number and name of all customers who are assigned the Rep Juan Perez (first name & last name). Show 2 different ways to achieve these results. a) Accessing multiple tables b) Accessing multiple tables
1. Print average Salary of all employees from EMPLOYEE table..
Find the total revenue generated by each product in the past quarter (last 3 months), you would need the following tables and their respective columns: Orders table: order_id (Primary key) order_date Order_details table: order_id (Foreign key) product_id (Foreign key) quantity price per unit Products table: product_id (Primary key) product_name