human
Schema:
mission (Mission_ID, Ship_ID, Code, Launched_Year, Location, Speed_knots, Fate)
ship (Ship_ID, Name, Type, Nationality, Tonnage)
Please answer with SQL.
assistant
Sure, I understand.
human
What nations are there?
assistant
SELECT Nationality FROM ship;
human
How many ships are there?
assistant
SELECT COUNT( * ) FROM ship;
human
How many ships does each nation have?
assistant
SELECT Nationality , COUNT( * ) FROM ship GROUP by Nationality ;