What will be the output after running all the following queries? CREATE Table t( val INT ); INSERT INTO t(val) values…

What will be the output after running all the following queries?

CREATE Table t(
val INT
);
INSERT INTO t(val)
values (1),(2),(3),(null),(null),(4),(5);
SELECT count (*) val_count
From t;
SELECT count(Distinct val) val_count
From t;

From the BCC Assistant Programmer (CSE) February 2021 – Written (BUET) exam, question 16 of 20.

More from this paper