Given the product table structure, which of the SQL statement will execute without any errors and give the correct results?

$\backslash$table$[[$Field$,$Type,Null,Key,Default,Extra$],[$ProductNum$,{\displaystyle \underset{\phantom{}}{\overset{\phantom{}}{}}}(11),$NO$,$PRI,,auto increment$],[$Descr$,$char$(20),$YES,,,$],[$ProductType$,$char$(15),$YES,,$0,],[$MSRP$,$decimal $(8,2),$YES,,mos,$],[$Onhand$,{\displaystyle \underset{\phantom{}}{\overset{\phantom{}}{}}}(4),$YES,,cons,$]]$

SELECT productnum, count$(")$

FROM product;

SELECT descr, count$()$

FROM product

ORDER BY productnum;

CREATE VIEW vProduct AS

SELECT descr, productnum

FROM product

WHERE onhand $>1$

ORDER BY descr;