Question Description
The employee information in a company is stored in the relation. Assume name is the primary key:Employee: (name, sex, salary, deptName)Consider the SQL query;SELECT deptNameFROM EmployeeWHERE sex = MGROUP By deptNameHAVING avg(salary) > (SELECT avg(salary)FROM Employee)It returns the names of the departments in which the average salary.a)Is more than the average salary in the company.b)Of the male employees is more than the average salary of all the male employees in the company.c)Of the male employees is more than the average salary of the employees in the same department.d)Of the male employees is more than the average salary in the company.Correct answer is option 'D'. Can you explain this answer? for Computer Science Engineering (CSE) 2024 is part of Computer Science Engineering (CSE) preparation. The Question and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus. Information about The employee information in a company is stored in the relation. Assume name is the primary key:Employee: (name, sex, salary, deptName)Consider the SQL query;SELECT deptNameFROM EmployeeWHERE sex = MGROUP By deptNameHAVING avg(salary) > (SELECT avg(salary)FROM Employee)It returns the names of the departments in which the average salary.a)Is more than the average salary in the company.b)Of the male employees is more than the average salary of all the male employees in the company.c)Of the male employees is more than the average salary of the employees in the same department.d)Of the male employees is more than the average salary in the company.Correct answer is option 'D'. Can you explain this answer? covers all topics & solutions for Computer Science Engineering (CSE) 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for The employee information in a company is stored in the relation. Assume name is the primary key:Employee: (name, sex, salary, deptName)Consider the SQL query;SELECT deptNameFROM EmployeeWHERE sex = MGROUP By deptNameHAVING avg(salary) > (SELECT avg(salary)FROM Employee)It returns the names of the departments in which the average salary.a)Is more than the average salary in the company.b)Of the male employees is more than the average salary of all the male employees in the company.c)Of the male employees is more than the average salary of the employees in the same department.d)Of the male employees is more than the average salary in the company.Correct answer is option 'D'. Can you explain this answer?.

Solutions for The employee information in a company is stored in the relation. Assume name is the primary key:Employee: (name, sex, salary, deptName)Consider the SQL query;SELECT deptNameFROM EmployeeWHERE sex = MGROUP By deptNameHAVING avg(salary) > (SELECT avg(salary)FROM Employee)It returns the names of the departments in which the average salary.a)Is more than the average salary in the company.b)Of the male employees is more than the average salary of all the male employees in the company.c)Of the male employees is more than the average salary of the employees in the same department.d)Of the male employees is more than the average salary in the company.Correct answer is option 'D'. Can you explain this answer? in English & in Hindi are available as part of our courses for Computer Science Engineering (CSE). Download more important topics, notes, lectures and mock test series for Computer Science Engineering (CSE) Exam by signing up for free.

Here you can find the meaning of The employee information in a company is stored in the relation. Assume name is the primary key:Employee: (name, sex, salary, deptName)Consider the SQL query;SELECT deptNameFROM EmployeeWHERE sex = MGROUP By deptNameHAVING avg(salary) > (SELECT avg(salary)FROM Employee)It returns the names of the departments in which the average salary.a)Is more than the average salary in the company.b)Of the male employees is more than the average salary of all the male employees in the company.c)Of the male employees is more than the average salary of the employees in the same department.d)Of the male employees is more than the average salary in the company.Correct answer is option 'D'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of The employee information in a company is stored in the relation. Assume name is the primary key:Employee: (name, sex, salary, deptName)Consider the SQL query;SELECT deptNameFROM EmployeeWHERE sex = MGROUP By deptNameHAVING avg(salary) > (SELECT avg(salary)FROM Employee)It returns the names of the departments in which the average salary.a)Is more than the average salary in the company.b)Of the male employees is more than the average salary of all the male employees in the company.c)Of the male employees is more than the average salary of the employees in the same department.d)Of the male employees is more than the average salary in the company.Correct answer is option 'D'. Can you explain this answer?, a detailed solution for The employee information in a company is stored in the relation. Assume name is the primary key:Employee: (name, sex, salary, deptName)Consider the SQL query;SELECT deptNameFROM EmployeeWHERE sex = MGROUP By deptNameHAVING avg(salary) > (SELECT avg(salary)FROM Employee)It returns the names of the departments in which the average salary.a)Is more than the average salary in the company.b)Of the male employees is more than the average salary of all the male employees in the company.c)Of the male employees is more than the average salary of the employees in the same department.d)Of the male employees is more than the average salary in the company.Correct answer is option 'D'. Can you explain this answer? has been provided alongside types of The employee information in a company is stored in the relation. Assume name is the primary key:Employee: (name, sex, salary, deptName)Consider the SQL query;SELECT deptNameFROM EmployeeWHERE sex = MGROUP By deptNameHAVING avg(salary) > (SELECT avg(salary)FROM Employee)It returns the names of the departments in which the average salary.a)Is more than the average salary in the company.b)Of the male employees is more than the average salary of all the male employees in the company.c)Of the male employees is more than the average salary of the employees in the same department.d)Of the male employees is more than the average salary in the company.Correct answer is option 'D'. Can you explain this answer? theory, EduRev gives you an ample number of questions to practice The employee information in a company is stored in the relation. Assume name is the primary key:Employee: (name, sex, salary, deptName)Consider the SQL query;SELECT deptNameFROM EmployeeWHERE sex = MGROUP By deptNameHAVING avg(salary) > (SELECT avg(salary)FROM Employee)It returns the names of the departments in which the average salary.a)Is more than the average salary in the company.b)Of the male employees is more than the average salary of all the male employees in the company.c)Of the male employees is more than the average salary of the employees in the same department.d)Of the male employees is more than the average salary in the company.Correct answer is option 'D'. Can you explain this answer? tests, examples and also practice Computer Science Engineering (CSE) tests.