from this data source, write in BigQuery a the function to answer the following:

4. Create a view of all the Gifted and Talented programs and their Rigorous_Instruction_Score, Effective_School_Leadership_Score, and Strong_Family_Community_Ties_Score. Use this view to calculate the most positively rated Gifted and Talented program by finding the sum of these ratings for each school in the view. I expect you to run two queries: one to create the view, the second to query the view for the answer to this question. Your response should contain both queries, and the most positively rated program.

Table name GCS link NYC Open data link Daily Attendance ge: //analytical_sql_home https://data.cityofnewyo work/2018-2019_Daily_Att rk.us/Education/2018-201 endance.cev 9-Daily-Attendance/x3bb- kg5j School_Demographic_Snaps gs://analytical_sql_home https://data.cityofnewyo hot work/2018-2019_School_De rk.us/Education/2018-201 mographic_Snapehot.cev 9-School-Demographic-Sna pehot/45j8-f6um DOE_Gifted_and_Talented ge://analytical_eqi_home https://data.cityofnewyo Admissions Guide work/2019_DOE_Gifted_and rk.us/Education/2019-DOE Talented_Admissione_Gui -Gifted-and-Talented-Adm issione-Guide/k65y-fzgg de.cev DOB_High_School Director ge: //analytical_sql_home https://data.cityofnewyo work/2019_DOE_High Schoo rk.us/Education/2019-DOE 1_Directory.cev -High-School-Directory/u q7m-9528 DOE_Teacher_Responses ge: //analytical_eqi_home https://data.cityofnewyo work/DOE_Teacher_Respons rk.us/Education/2019-Pub lic-Data-File-Teachers/h vwa-bi3h ee.cev Table name GCS link NYC Open data link Daily Attendance ge: //analytical_sql_home https://data.cityofnewyo work/2018-2019_Daily_Att rk.us/Education/2018-201 endance.cev 9-Daily-Attendance/x3bb- kg5j School_Demographic_Snaps gs://analytical_sql_home https://data.cityofnewyo hot work/2018-2019_School_De rk.us/Education/2018-201 mographic_Snapehot.cev 9-School-Demographic-Sna pehot/45j8-f6um DOE_Gifted_and_Talented ge://analytical_eqi_home https://data.cityofnewyo Admissions Guide work/2019_DOE_Gifted_and rk.us/Education/2019-DOE Talented_Admissione_Gui -Gifted-and-Talented-Adm issione-Guide/k65y-fzgg de.cev DOB_High_School Director ge: //analytical_sql_home https://data.cityofnewyo work/2019_DOE_High Schoo rk.us/Education/2019-DOE 1_Directory.cev -High-School-Directory/u q7m-9528 DOE_Teacher_Responses ge: //analytical_eqi_home https://data.cityofnewyo work/DOE_Teacher_Respons rk.us/Education/2019-Pub lic-Data-File-Teachers/h vwa-bi3h ee.cev