Please show the results of music festivals and the number of music festivals that have had each, ordered by this count.
CREATE TABLE music_festival (RESULT VARCHAR)
SELECT RESULT, COUNT(*) FROM music_festival GROUP BY RESULT ORDER BY COUNT(*) DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE music_festival (RESULT VARCHAR) Question: Please show the results of music festivals and the number of music festivals that have had each, ordered by this count. [/INST] SELECT RESULT, COUNT(*) FROM music_festival GROUP BY RESULT ORDER BY COUNT(*) DESC </s>