SQLQuestion 13 of 14Multiple choiceCOUNT(*), COUNT(1), COUNT(column) and NULLBookmarkReview laterWhat does the query return (in order: rows, ones, non_null, unique_values)?SQLWITH sample(value) AS (VALUES (10), (NULL), (10)) SELECT COUNT(*) AS rows, COUNT(1) AS ones, COUNT(value) AS non_null, COUNT(DISTINCT value) AS unique_values FROM sample;Choose one answer.A.3, 3, 2, 1B.3, 2, 2, 1C.3, 3, 3, 1D.2, 2, 2, 1Check answerBased on the cardCOUNT(*) vs COUNT(1) vs COUNT(column) — SQL