Who is the professional partner of celebrity małgorzata foremniak with a season less than 7, an average greater than 34.66, and a rank less than 10?
CREATE TABLE table_name_52 (professional_partner VARCHAR, celebrity VARCHAR, rank VARCHAR, season VARCHAR, average VARCHAR)
SELECT professional_partner FROM table_name_52 WHERE season < 7 AND average > 34.66 AND rank < 10 AND celebrity = "małgorzata foremniak"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_52 (professional_partner VARCHAR, celebrity VARCHAR, rank VARCHAR, season VARCHAR, average VARCHAR) Question: Who is the professional partner of celebrity małgorzata foremniak with a season less than 7, an average greater than 34.66, and a rank less than 10? [/INST] SELECT professional_partner FROM table_name_52 WHERE season < 7 AND average > 34.66 AND rank < 10 AND celebrity = "małgorzata foremniak" </s>