What is the id of the product that was ordered the most often?
CREATE TABLE order_items (product_id VARCHAR)
SELECT TOP 1 product_id FROM order_items GROUP BY product_id ORDER BY COUNT(*) DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE order_items (product_id VARCHAR) Question: What is the id of the product that was ordered the most often? [/INST] SELECT TOP 1 product_id FROM order_items GROUP BY product_id ORDER BY COUNT(*) DESC </s>