How many positions have points against less than 28, americano-sp as the team, with a played greater than 8?
CREATE TABLE table_name_7 (position VARCHAR, played VARCHAR, against VARCHAR, team VARCHAR)
SELECT COUNT(position) FROM table_name_7 WHERE against < 28 AND team = "americano-sp" AND played > 8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_7 (position VARCHAR, played VARCHAR, against VARCHAR, team VARCHAR) Question: How many positions have points against less than 28, americano-sp as the team, with a played greater than 8? [/INST] SELECT COUNT(position) FROM table_name_7 WHERE against < 28 AND team = "americano-sp" AND played > 8 </s>