Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Find out Occupation of all the users Find out numbers of non-adults, who has rated movies: Find out the no of users with same occupation

Find out Occupation of all the users

Find out numbers of non-adults, who has rated movies:

Find out the no of users with same occupation and having age more than 25 along with occupation details: Find the age of the most rated user with counts of rating;

I need the script tax

image text in transcribed

users.userid users.gender users.age users.occupation_id users.zipcode 1 F 1 10 48067 2 M 56 16 70072 1 movies.movieid movies.title movies.genres Toy Story (1995) ["Animation", Children's", Comedy'] Jumanji (1995) l'Adventure Children's". 'Fantasy'] 2 occupations.id occupations.occupation 0 otherot specified academic/educator 1 ratings.userid ratings.movieid ratings.rating ratings.tstamp 1 1193 5 978300760 1 661 3 978302109

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students explore these related Databases questions