What-all the most highest a tonnage Brig Ship Type and a disposition Ship Prize?
Date Ship Name Tonnage Ship Type Location Disposition of Ship
USS Wasp (1814)
18137936
text text real text text text
2-18137936-1
First Raiding Cruise
First raiding cruise
2 June 1814 Neptune 207 Barque English Channel Burned
13 William 91 Brig “ Burned
18 Pallas 131 Brig “ Scuttled
23 Henrietta 171 Galiot “ Prize; used to transport prisoners
26 Orange Boven 325 Ship “ scuttled
28 HMS Reindeer 385 18-gun Sloop “ Captured
4 July Regulator 112 Brig “ Prize
6 Jenny 151 Schooner “ Prize
SELECT MAX Tonnage FROM table WHERE Ship Type = brig AND Disposition of Ship = prize
brig prize