Table: ship_launches_1878
Columns: country
builder
location
ship
class_type

Question: Which ship was launched from Devonport, Devon?
SQL: SELECT "ship" FROM ship_launches_1878 WHERE "location" = 'devonport, devon'

Question: What country was the Pegasus, build by Royal Dockyard, from?
SQL: SELECT "country" FROM ship_launches_1878 WHERE "builder" = 'royal dockyard' AND "ship" = 'pegasus'

Question: Who was the builder of Gannet from the United Kingdom?
SQL: SELECT "builder" FROM ship_launches_1878 WHERE "country" = 'united kingdom' AND "ship" = 'gannet'

Question: Who was the builder of Nor?
SQL: SELECT "builder" FROM ship_launches_1878 WHERE "ship" = 'nor'

Question: Who was the builder of Brage from Norway?
SQL: SELECT "builder" FROM ship_launches_1878 WHERE "country" = 'norway' AND "ship" = 'brage'

Question: What country was Brage, built by karljohansverns verft, from?
SQL: SELECT "country" FROM ship_launches_1878 WHERE "builder" = 'karljohansverns verft' AND "ship" = 'brage'