Grouping Data
MCQ - 1
Ans : a
MCQ - 2
MCQ - 3
MCQ - 4
MCQ - 5
Ans : d
MCQ - 6
MCQ - 7
Ans : d
MCQ - 8
MCQ - 9
Ans : b
MCQ - 10
Ans : d
SELECT gender FROM customer GROUP BY gender;
SQL query - 2
SELECT year_of_joining FROM employee WHERE year_of_joining>2010 GROUP BY year_of_joining;
SQL query - 3
SELECT dept_id FROM employee WHERE salary>50000 GROUP BY dept_id;
SQL query - 4
SELECT city, count(cname) AS Cust_num FROM customer GROUP BY city;
SQL query - 5
SELECT address, SUM(totalordersyet) FROM customer GROUP BY address;
SQL query - 6
SELECT pincode, MAX(totalordersyet) FROM customer GROUP BY pincode;
SQL query - 7
SELECT GENDER, MIN(TOTALORDERSYET) FROM CUSTOMER GROUP BY GENDER;
SQL query - 8
SELECT city, AVG(TOTALORDERSYET) FROM customer GROUP BY city;
SQL query - 9
SELECT city, COUNT(cname) AS Number FROM customer GROUP BY CITY ORDER BY Number DESC;
SQL query - 10
SELECT address, count(address) AS Address_times FROM customer WHERE city='Jalandhar' GROUP BY address;
SQL query - 11
SELECT job, COUNT(empfname) AS empnum FROM employee_data GROUP BY job;
SQL query - 12
SELECT job, deptcode, COUNT(job) AS number_of_employees FROM employee_data GROUP BY job, deptcode;
SQL query - 13
SELECT job, MAX(salary) FROM employee_data GROUP BY job;
SQL query - 14
SELECT job, deptcode, AVG(salary) FROM employee_data GROUP BY job, deptcode;
SQL query - 15
SELECT job, deptcode, MIN(salary) FROM employee_data GROUP BY job, deptcode ORDER BY MAX(salary) DESC;
SQL query - 16
SELECT dept_id, COUNT(emp_id) AS Emp_num FROM employee GROUP BY dept_id;
SQL query - 17
SELECT address, city, pincode FROM customer GROUP BY address, city, pincode HAVING COUNT(address)>2;
SQL query - 18
SELECT address FROM customer WHERE city ='Guwahati' GROUP BY address HAVING MAX(TotalOrdersYet);
SQL query - 19
SELECT job FROM employee_data GROUP BY job HAVING AVG(salary)>3000;
SQL query - 20
SELECT deptcode FROM employee_data GROUP BY deptcode HAVING SUM(salary)>5000 ORDER BY MIN(salary);
SQL query - 21
SELECT Manager, COUNT(empcode) AS 'Number of Employees' FROM employee_data WHERE deptcode NOT IN (10,20) GROUP BY Manager HAVING COUNT(empcode)>2;
SQL query - 22
SELECT job, Deptcode, manager, MAX(salary) FROM employee_data WHERE job='ANALYST' GROUP BY job, deptcode, manager ORDER BY SUM(salary);
