what is the number of points when the place is less than 7, the draw is more than 2 and the artist is piece of cake?
CREATE TABLE table_name_76 (points VARCHAR, artist VARCHAR, place VARCHAR, draw VARCHAR)
SELECT COUNT(points) FROM table_name_76 WHERE place < 7 AND draw > 2 AND artist = "piece of cake"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_76 (points VARCHAR, artist VARCHAR, place VARCHAR, draw VARCHAR) Question: what is the number of points when the place is less than 7, the draw is more than 2 and the artist is piece of cake? [/INST] SELECT COUNT(points) FROM table_name_76 WHERE place < 7 AND draw > 2 AND artist = "piece of cake" </s>