Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Me diga as armas para um navio de terceira categoria e o posto de vice-almirante com o ano de 1802.
 ###Tabelas: CREATE TABLE populations (populations_id AUTO_INCREMENT PRIMARY KEY, Country VARCHAR, Orphans as % of all Children INT, AIDS Orphans as % of Orphans INT, Total Orphans (Total) INT, Total Orphans (AIDS Related) VARCHAR, Maternal (Total) INT, Maternal (AIDS Related) VARCHAR, Paternal (Total) INT, Paternal (AIDS Related) VARCHAR, Double (Total) INT, Double (AIDS Related) VARCHAR) CREATE TABLE greek_cup_finals (greek_cup_finals_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, Winner VARCHAR, Runner-up VARCHAR, Score VARCHAR, Venue VARCHAR) CREATE TABLE final_league_positions_since_1992 (final_league_positions_since_1992_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Div. VARCHAR, Pos. INT, Top Scorer (League) VARCHAR, Head Coach VARCHAR) CREATE TABLE cryengine (cryengine_id AUTO_INCREMENT PRIMARY KEY, Title VARCHAR, Year VARCHAR, Developer VARCHAR, Publisher VARCHAR, Platform VARCHAR) CREATE TABLE ships_in_which_bolitho_serves (ships_in_which_bolitho_serves_id AUTO_INCREMENT PRIMARY KEY, Ship VARCHAR, Guns VARCHAR, Class VARCHAR, Captain VARCHAR, Rank VARCHAR, Year VARCHAR)  
SELECT Guns FROM ships_in_which_bolitho_serves WHERE Class = third-rate ship of the line AND Rank = vice-admiral AND Year = 1802