1 Find the return value If no record founded... SELECT SUM(price) FROM product WHERE id>100 SELECT COUNT(price) FROM product WHERE id>100 SELECT AVG(price) FROM product WHERE id>100 SELECT MIN(price) FROM product WHERE id>100 Explanation: SUM () returns NULL COUNT(*) returns 0 AVG(price) returns NULL MIN(price) returns NULL View Answer
Find the return value If no record founded...
SELECT SUM(price) FROM product WHERE id>100
SELECT COUNT(price) FROM product WHERE id>100
SELECT AVG(price) FROM product WHERE id>100
SELECT MIN(price) FROM product WHERE id>100
SUM () returns NULL
COUNT(*) returns 0
AVG(price) returns NULL
MIN(price) returns NULL