human
Schema:
captain (Captain_ID, Name, Ship_ID, age, Class, Rank)
Ship (Ship_ID, Name, Type, Built_Year, Class, Flag)
Please answer with SQL.
assistant
Sure, I understand.
human
how many ship there
assistant
SELECT COUNT( * ) FROM ship;
human
what is the name of ship id 2
assistant
SELECT Name FROM ship WHERE Ship_ID = 2;
human
what is the built year of the ship id 3
assistant
SELECT Built_Year FROM ship WHERE Ship_ID = 3 ;