Explain why the following two commands produce different results: SELECT DISTINCT COUNT (V_CODE) FROM PRODUCT; SELECT COUNT (DISTINCT V_CODE) FROM PRODUCT;

4. In the OrderItems table, display a count of the number of products, grouped by prod_id, but only for those groups having 3 or more of a given prod_id. Display the count with the alias shown. Sort by prod_id in ascending order. BNBG01 BNBG02 BNBG03 BR03 4 rows returned in 0.00 seconds PROD_ID Download 3 3 3 4 NUM_PROD_ID

i amm trying to do some work in sql developer   insert data from nametest to names  i want only to insert year ,name and gender ,then create a id for each data in the databse . what commend shouldi  use ?  i try "INSERT INTO names(Year, Name, gender),SELECT (Year_, name_, genderA) FROM namestest; it shows  Error starting at line : 1 in command -INSERT INTO names(Year, Name, gender),SELECT (Year_, name_, genderA) FROM namestestError at Command Line : 2 Column : 21Error report -SQL Error: ORA-00926: missing VALUES keyword00926. 00000 -  "missing VALUES keyword"*Cause:     how to make it corrrect ?and make a "id "for each data ?

The following two SQL statements will produce the same results. SELECT P_DESCRIPT, P_QOH,P_PRICE FROM PRODUCT WHERE P_QOH >(SELECT P_QOH FROM PRODUCT WHERE P_CODE='11QER/31') AND   P_PRICE>(SELECT P_PRICE FROM PRODUCT WHERE P_CODE='11QER/31');     SELECT P_DESCRIPT, P_QOH,P_PRICE FROM PRODUCT WHERE (P_QOH,P_PRICE) >  (SELECT P_QOH,P_PRICE  FROM PRODUCT   WHERE P_CODE='11QER/31');   A) True B) False