CREATE TABLE artwork (TYPE VARCHAR)

Please show different types of artworks with the corresponding number of artworks of each type.
SELECT TYPE, COUNT(*) FROM artwork GROUP BY TYPE
SELECT "TYPE", COUNT(*) FROM "artwork" GROUP BY "TYPE"