What is the average rating for right-footed players and left-footed players?
CREATE TABLE Player_Attributes (preferred_foot VARCHAR, overall_rating INTEGER)
SELECT preferred_foot, AVG(overall_rating) FROM Player_Attributes GROUP BY preferred_foot
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Player_Attributes (preferred_foot VARCHAR, overall_rating INTEGER) Question: What is the average rating for right-footed players and left-footed players? [/INST] SELECT preferred_foot, AVG(overall_rating) FROM Player_Attributes GROUP BY preferred_foot </s>