Name the number of names for exeter chiefs
CREATE TABLE table_22977424_8 (name VARCHAR, promoted_from_league VARCHAR)
SELECT COUNT(name) FROM table_22977424_8 WHERE promoted_from_league = "Exeter Chiefs"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_22977424_8 (name VARCHAR, promoted_from_league VARCHAR) Question: Name the number of names for exeter chiefs [/INST] SELECT COUNT(name) FROM table_22977424_8 WHERE promoted_from_league = "Exeter Chiefs" </s>