Find the names of the artists who have produced English songs but have never received rating higher than 8.
CREATE TABLE song (artist_name VARCHAR, languages VARCHAR, rating INTEGER)
SELECT DISTINCT artist_name FROM song WHERE languages = "english" EXCEPT SELECT DISTINCT artist_name FROM song WHERE rating > 8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE song (artist_name VARCHAR, languages VARCHAR, rating INTEGER) Question: Find the names of the artists who have produced English songs but have never received rating higher than 8. [/INST] SELECT DISTINCT artist_name FROM song WHERE languages = "english" EXCEPT SELECT DISTINCT artist_name FROM song WHERE rating > 8 </s>