New Register here for RBI, SEBI & NABARD strategy workshop! April 9 at 7 PM

    Question

    What is the result of the following SQL query?

     SELECT department, COUNT (employee_id)  FROM employees GROUPBY department HAVING COUNT (employee_id) > 5 ;
    A Displays all employees whose department has more than 5 entries in the database. Correct Answer Incorrect Answer
    B Returns an error because HAVING cannot be used with aggregate functions. Correct Answer Incorrect Answer
    C Displays department names with more than 5 employees and their counts. Correct Answer Incorrect Answer
    D Returns all employees along with their respective department and count. Correct Answer Incorrect Answer
    E Counts the number of employees in each department but does not filter any results. Correct Answer Incorrect Answer

    Solution

    Explanation: This query groups employee data by the department column and calculates the count of employees for each department using COUNT(employee_id) . The HAVING clause filters groups to include only those with a count greater than 5. The HAVING clause is specifically used for filtering after applying aggregate functions, unlike WHERE , which filters rows before aggregation. This query is commonly used in scenarios like resource allocation, workforce analysis, and performance reporting. Option A: The query does not display individual employee details, only aggregated department data. Option B: HAVING is valid with aggregate functions, provided it follows GROUP BY . Option D: This interpretation mixes individual and aggregated data, which is not possible here. Option E: The HAVING clause explicitly filters results, so this option is incorrect.

    Practice Next