How many documents are with document type code BK for each product id?
CREATE TABLE Documents (project_id VARCHAR, document_type_code VARCHAR)
SELECT COUNT(*), project_id FROM Documents WHERE document_type_code = "BK" GROUP BY project_id
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Documents (project_id VARCHAR, document_type_code VARCHAR) Question: How many documents are with document type code BK for each product id? [/INST] SELECT COUNT(*), project_id FROM Documents WHERE document_type_code = "BK" GROUP BY project_id </s>