I need help in solving this syntax in hive:

1. Select t.year, count(*) as count from (Select regexp_extract(movie_name, '([1-2][0-9][0-9][0-9])',1) as year from *table* where genre='Thriller') t group by year order by count desc limit 5;

With some help from the "select" statement above -> create a table called movie_year_temp with following columns (movieid, movie_title, movie_year) in hive.