Find the number of students that have at least one grade "B".
CREATE TABLE ENROLLED_IN (StuID VARCHAR, Grade VARCHAR)
SELECT COUNT(DISTINCT StuID) FROM ENROLLED_IN WHERE Grade = "B"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE ENROLLED_IN (StuID VARCHAR, Grade VARCHAR) Question: Find the number of students that have at least one grade "B". [/INST] SELECT COUNT(DISTINCT StuID) FROM ENROLLED_IN WHERE Grade = "B" </s>