Start learning 50% faster. Sign in now
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.
How many farmers are targeted to be introduced to natural farming over the next two years?
What is one of the objectives of improved access to institutional credit in agriculture?
As per the report released by ISFR (2021), which state has the highest forest area.
How many varieties of high-yielding and climate-friendly crops will be released?
Which initiative is part of the Indian government’s efforts to digitize agriculture?
Which state is the largest producer of wheat in 2023-24 (Third Advance Estimate)?
What was the budget allocation for the Agriculture Infrastructure Fund (AIF) in 2024-25?
Share of Agri & Allied sector in Total GVA (2020-21) at Current Prices is
What is the purpose of the mActionSoft mobile-based solution introduced by the Ministry of Panchayati Raj?
Which scheme aims to provide income support to all farmer families across the country?