Here's a very simple SuiteQL query that returns the types of items that are setup in a NetSuite instance, and the count for each item type.

SELECT
   ItemType,
   COUNT(*) AS ItemCount
FROM
   Item
GROUP BY
   ItemType
ORDER BY
   ItemType