Issue while executing below query in mongodb atlas sql

Greetings @SUBHASH_V_K and welcome to the community!
This is hard to diagnose without more information (like the logs), but one thing I’d point out is that your sql syntax is not correct. Our dialect, is called mongosql and you can find more about it in our documentation. It is SQL-92 compatible. Here is how you would want to form your SQL Statement:

Select EXTRACT(YEAR FROM released) as Released_Year, COUNT(EXTRACT(YEAR FROM released))as Year_Count from Movies.movies
GROUP BY Released_Year

Let me know if you have further questions.