It shows

the names of all products in the table.

It produces

an error.

It shows the names of products whose list price is

the second highest in the table.

It

shows the names of all products whose list price is less than the maximum list

price.

Feature begins with two 0’s

Feature has two 0’s in it, at positions 2 and 4

Feature ends with two 0’s

Feature has two 0’s in it, at any position

Feature has more than two 0’s

statement 1 and statement 2 execute successfully and

give the same output

statement1

gives an error, statement2 executes successfully

statement 1 and statement 2 execute successfully

and give a different output

statement2

gives an error, statement1 executes successfully

4

3

1

No result

SELECT deptno, SUM(sal) AS totalsal FROM emp GROUP BY deptno where COUNT(empno) > 2

SELECT deptno, SUM(sal) AS totalsal FROM emp GROUP BY deptno HAVING COUNT(empno) > 2

SELECT deptno, SUM(sal) AS totalsal FROM emp GROUP BY deptno HAVING COUNT(empno) = 2

SELECT deptno, SUM(sal) AS totalsal FROM emp GROUP BY deptno where COUNT(empno) = 2

SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES ORDER BY STORE_ID;

SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES GROUP BY STORE_ID;

SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES HAVING UNIQUE STORE_ID;

4

3

2

5

SUM(salary)

MEAN(salary)

AVG(salary)

COUNT(salary)