Task: Text to Code
Input (English): find without repetition the id, name of ship table for which ship_type equals Brig
Output (English): SELECT DISTINCT id , name FROM ship WHERE ship_type = "Brig"