What is the sum of Year, when Role is "himself", and when Notes is "celebrity guest alongside yg family"?
CREATE TABLE table_name_39 (year INTEGER, role VARCHAR, notes VARCHAR)
SELECT SUM(year) FROM table_name_39 WHERE role = "himself" AND notes = "celebrity guest alongside yg family"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_39 (year INTEGER, role VARCHAR, notes VARCHAR) Question: What is the sum of Year, when Role is "himself", and when Notes is "celebrity guest alongside yg family"? [/INST] SELECT SUM(year) FROM table_name_39 WHERE role = "himself" AND notes = "celebrity guest alongside yg family" </s>