Please show the most common type of ships.
CREATE TABLE ship (
    TYPE VARCHAR
)
SELECT TYPE FROM ship GROUP BY TYPE ORDER BY COUNT(*) DESC LIMIT 1
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Please show the most common type of ships. ### Input: CREATE TABLE ship (
    TYPE VARCHAR
) ### Response: SELECT TYPE FROM ship GROUP BY TYPE ORDER BY COUNT(*) DESC LIMIT 1