CREATE TABLE table_name_40 (rebuilt VARCHAR, name_as_rebuilt VARCHAR)

Which Rebuilt has a Name as rebuilt of binevanagh?
SELECT rebuilt FROM table_name_40 WHERE name_as_rebuilt = "binevanagh"
SELECT "rebuilt" FROM "table_name_40" WHERE "binevanagh" = "name_as_rebuilt"