user: ### NOW ANSWER:
Question: Tell me the guns for Third-rate ship of the line and rank of Vice-admiral with year of 1802
Columns: ['Ship', 'Guns', 'Class', 'Captain', 'Rank', 'Year']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['HMS Manxman', '80', 'Third-rate ship of the line', 'Captain Sir Henry Langford', 'Midshipman', '1768–1772']
SQL:

assistant: SELECT "Guns" FROM "Table" WHERE "Class" = 'Third-rate ship of the line' AND "Rank" = 'Vice-admiral' AND "Year" = '1802';