data base multiple choise questions please. Given the table: emp [eid, ename, salary, d_id]The following query retrieve the department name that has the maximum number ofemployees:select d_namefrom depwhere d_id3(select d_idfrom emphaving sum(salary)=(select max(sum(salary))from empgroup by d_id));Select one:O TrueO False Given the table: emp [eid, ename, salary, d_id]The following sql statement retrieves:select max(sum(salary))from empgroup by d_id;Select one:a. sum of salaries of all departments - retrieve several valuesO b. maximum salary of all departments - retrieve several valuesO c. max salary of each department - retrieve only one valueO d. maximum sum of salaries of the departments in the company - retrieve one value

The first option definitely cannot be chosen because there would be some errors in the…

Given the table: emp [eid, ename, salary, d_id] The following query retrieve the department name that has the maximum number of employees: select d_name from dep where d_id%3D( select d_id from emp having sum(salary)= (select max(sum(salary)) from emp group by d_id)); Select one: O True O False

Given the table: emp [eid, ename, salary, d_id] The following query retrieve the department name that has the maximum number of employees: select d_name from dep where d_id%3D( select d_id from emp having sum(salary)= (select max(sum(salary)) from emp group by d_id)); Select one: O True O False

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

databaes sql
Display manager ID and number of employees managed bythe manager. using sql plus hr user
Table Products:- ID, Name, Price. Calculate a new column named Discounted_Price following these conditions:- $18 minus if the original Price is above $120. $10 if the original Price is between $70 and $120 Original price for all other cases. Filter products with a Discounted_Price greater than $95. display the ProductID, Product Name, Price, and Discounted Price.
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
SQL BITS List client number, balance, consultant number, and consultant last name of every client whose balance is greater than that of client number '405.'
What’s the purpose of a column qualifier? When are you required to use one?
Count and display the booking code of customers who already paid for booking.
Column name Datatype Description trainer_id Should increment what is the datatype and size?
please do this mysql problem in less time
Please help from attached file. Find the distinct number of workers who work in the HR department and who earn more than ₹250,000. Find the last name and title of all workers and the department they work in who earn less than the average salary. What is the average salary paid for all workers in each department? List the department, the average salary for the department, and the number of workers in each department. Name the average column 'AvgSal' and the number of workers column to 'Num'. What is the total compensation for each worker (salary and bonus) on a per monthly basis? List the name of the worker, their title, and the their monthly compensation (annual compensation divided by 12). Change the header for compensation to 'MonthlyComp' and round it to the nearest whole number. List the full names of all workers in all capital letters who did not get a bonus. What are the full names of all workers who have 'Manager' in their title. Do not "hard code" the titles; use string…
Computer Science A study conducted by Netflix’s consumer relations department has revealed that customers are more likely to review horror and thriller movies during certain months of the year. To discourage seasonal variations in these movie ratings, Netflix has called for your help to analyze horror and thriller movie rating counts over the past 15 years. Your query should display each month of the year (name of the month not the number) and the total number of ratings given during that month. A third column titled “Promotion Recommendation” determines whether a promotion should be applied to increase the number of ratings given during that month. If a month has less than 2200 ratings the final column should display ‘10% discount promotion’, if between 2201 and 4500 then display ‘5% discount promotion’, and if more than 4500 ratings then output ‘No Promotion’. Order your results by months. Do not hardcode the current date. ORALCE CODE PLEASE.
database HR list the last name and salary of employees who earn between $5,000 and $12,000, and are in department 20 or 50. Label the columns Employee and Monthly Salary, respectively.