Table schema:
CREATE TABLE table_name_74 (studio VARCHAR, role VARCHAR)

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