CREATE TABLE table_name_74 (studio VARCHAR, role VARCHAR)

Name the studio for john scott
SELECT studio FROM table_name_74 WHERE role = "john scott"
SELECT "studio" FROM "table_name_74" WHERE "john scott" = "role"