"What are the most popular movies for different age groups?"

Data set user.dat has an information about age groups

1: "Under 18"

18: "18-24"

25: "25-34"

35: "35-44"

45: "45-49"

50: "50-55"

56: "56+"

I have provided a movie ID for the movie that has the highest number of ratings and that number for each age group from datasets in ml-1m.zip file. The output of HiveQL script is in 000000_0 file. Thank You