Question
I asked the same question before, but I am not happy with the answer. Whoever answered that, answered with mere negligence. I know chegg has
I asked the same question before, but I am not happy with the answer. Whoever answered that, answered with mere negligence. I know chegg has better people to answer this question. Thank You!!
Using the Assignment 7 ACCESS DatabaseFile (I attached the google drive access database link below) To work on this homework, I recommend that you test-run a query, save it when you succeed, then work on the next query on the same page. Once you are done with all queries, save your SQL file as a single PDF file. This is the file that you will submit through Moodle.
QUERIES:
1. Get the reviewers ID and their occupations
2. Get the movie title for all movies that are comedy or horror, rename the output attribute name to be Happily Scared
3. Get the reviewer ID for male students or students older than 30.
4. What are the occupations that are NOT student, lawyer or educator? List them in descending alphabetical order
5. List all movies released in 1982, sorted by alphabetical order
6. List all mean reviewers and their average rating scores mean reviewers are reviewers whose average rating score is less than 2
7. List the oldest age of reviewers for each profession
8. List number of reviewers for each profession, not including students or educators
9. List the average student reviewers age by gender
10. List all occupations in which the female reviewers have an average age above 40
The database's link in google drive: https://drive.google.com/file/d/1to15QUVnskMX_elfQtvTIFFGrK8BmDI3/view?usp=sharing
Search... MOVIE Tables Field Name Data Type MOVIE RATING VIEWER MovielD MovieTitle IMDB URL unkown adventure animantion children comedy crime documenta dra fantasy noir horror musical mystery romance scifi thriller Number Short Text Short Text Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number VIEWER Field Name Data Type UserID Age Gender Occupation Zip Number Number Short Text Long Text Long Text RATING Field Name Data Type UserID MovielD Rating Number Number NumberStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started