find the number of players whose points are lower than 30 in each position.
CREATE TABLE player (POSITION VARCHAR, points INTEGER)
SELECT COUNT(*), POSITION FROM player WHERE points < 30 GROUP BY POSITION
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE player (POSITION VARCHAR, points INTEGER) Question: find the number of players whose points are lower than 30 in each position. [/INST] SELECT COUNT(*), POSITION FROM player WHERE points < 30 GROUP BY POSITION </s>