What is HMS Gorgon's rank?
select T1.Rank from captain as T1 join  Ship as T2 on  T1.Ship_ID = T2.Ship_ID where T2.Name = "HMS Gorgon"
HMS Gorgon's rank refers to Rank in captain table; joining on Ship_ID to relate captain to Ship where Ship's Name = 'HMS Gorgon';