SELECT name ,  CLASS FROM ship WHERE ship_id NOT IN (SELECT ship_id FROM captain)
SELECT name ,  CLASS FROM ship WHERE ship_id NOT IN (SELECT ship_id FROM captain) <table_name> : captain col : Captain_ID | Name | Ship_ID | age | Class | Rank row 1 : 1 | Captain Sir Henry Langford | 1 | 40 | Third-rate ship of the line | Midshipman row 2 : 2 | Captain Beves Conway | 2 | 54 | Third-rate ship of the line | Midshipman row 3 : 3 | Lieutenant Hugh Bolitho | 3 | 43 | Cutter | Midshipman row 4 : 4 | Lieutenant Montagu Verling | 4 | 45 | Armed schooner | Midshipman row 5 : 5 | Captain Henry Dumaresq | 5 | 38 | Frigate | Lieutenant row 6 : 6 | Captain Gilbert Pears | 2 | 60 | Third-rate ship of the line | Lieutenant row 7 : 7 | Commander Richard Bolitho | 3 | 38 | Sloop-of-war | Commander, junior captain <table_name> : Ship col : Ship_ID | Name | Type | Built_Year | Class | Flag row 1 : 1 | HMS Manxman | Panamax | 1997 | KR | Panama row 2 : 2 | HMS Gorgon | Panamax | 1998 | KR | Panama row 3 : 3 | HM Cutter Avenger | Panamax | 1997 | KR | Panama row 4 : 4 | HM Schooner Hotspur | Panamax | 1998 | KR | Panama row 5 : 5 | HMS Destiny | Panamax | 1998 | KR | Panama row 6 : 6 | HMS Trojan | Panamax | 1997 | KR | Panama row 7 : 7 | HM Sloop Sparrow | Panamax | 1997 | KR | Panama row 8 : 8 | HMS Phalarope | Panamax | 1997 | KR | Panama row 9 : 9 | HMS Undine | Panamax | 1998 | GL | Malta
col : Name | Class row 1 : HMS Trojan | KR row 2 : HM Sloop Sparrow | KR row 3 : HMS Phalarope | KR row 4 : HMS Undine | GL