Assume there is a table name ITEM with below data:
ITEMNO ITEMNAME VENDORID
IT111 RULER V1111
IT112 GEOMETRY BOX V1112
IT113 NOTES V1111
IT114 COLOR BOOK V1112
IT115 CLAY BOX V1113
What will be the output of the following query?
SELECT COUNT(ITEMNO) FROM ITEM GROUP BY VENDORID;