User

table$-$Movie

attributes$-$ movieid $-$ int,title $-$ string,genres $-$ string

table $-$ ratings

attributes $-$ userid $-$ int, movieid$-$int,rating float.

table $-$ users

attributes $-$ userid $-$ int, gender $-$ char, age $-$ int, occupation$\_$code $-$ int, zip$\_$code $-$ int

Perform the following tasks:

$1.$Print the age and total count of ratings given by the userId $100.$

$2.$List the count of ratings for each distinct userId.

$3.$List top $10$ movieId and titles with highest rating in the descending order.

Find the top $3$ popular genre movies w$.$r$.$t total numbers of ratings received. Sort the genres in the descending order. Print the genre and the count of ratings.

$4.$List all movies with genre of movie is $$Fantasy$$ and $$Adventure$.$

$5.$List movie ids of all movies with rating equal to $4.$

$6.$Find top $10$ highly rated "Comedy" movies with descending order of rating