Who is the h.s. principal with Dave Lovering as w.r. principal and Marty Pizur as m.s. principal?
CREATE TABLE table_name_99 (hs_principal VARCHAR, wr_principal VARCHAR, ms_principal VARCHAR)
SELECT hs_principal FROM table_name_99 WHERE wr_principal = "dave lovering" AND ms_principal = "marty pizur"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_99 (hs_principal VARCHAR, wr_principal VARCHAR, ms_principal VARCHAR) Question: Who is the h.s. principal with Dave Lovering as w.r. principal and Marty Pizur as m.s. principal? [/INST] SELECT hs_principal FROM table_name_99 WHERE wr_principal = "dave lovering" AND ms_principal = "marty pizur" </s>