CREATE TABLE ship (TYPE VARCHAR)

Please show the most common type of ships.
SELECT TYPE FROM ship GROUP BY TYPE ORDER BY COUNT(*) DESC LIMIT 1
SELECT "TYPE" FROM "ship" GROUP BY "TYPE" ORDER BY COUNT(*) DESC NULLS LAST LIMIT 1