To find out the section number (denoted by SECNO) and number of employees (denoted by EMPNO) working in that section from the employee database (denoted by EMP), the correct SQL command shall be:
1
SELECT SECNO,
COUNT(EMPNO)
FROM EMP
GROUP BY SECNO;
2
SELECT EMPNO
FROM SECNO
GROUP BY SECNO;
3
SELECT SECNO,
FROM EMP
GROUP BY EMPNO;
4
SELECT SECNO,
COUNT(EMPNO)
FROM SECNO, EMPNO
GROUP BY SECNO;