text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  CREATE TABLE table_name_63 (guns VARCHAR, year VARCHAR, class VARCHAR, rank VARCHAR)
  ### Question:
  Tell me the guns for third-rate ship of the line and rank of vice-admiral with year of 1802
  ### Answer:
  SELECT guns FROM table_name_63 WHERE class = "third-rate ship of the line" AND rank = "vice-admiral" AND year = "1802"