Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

4. Change the ratings for the movies according to the following rules. The rating should be: - 8.3 for all movies with duration greater than

image text in transcribed
image text in transcribed
4. Change the ratings for the movies according to the following rules. The rating should be: - 8.3 for all movies with duration greater than 100 , - 9.0 for all movies with duration between 90 and 95 (including 90 and 95 ), - the rating for all other movies must remain unchanged. Important: - Use only one UPDATE statement (with a CASE) to set the ratings of all the movies. Take a screenshot now and paste it here. 5. Show all the data in your table movie. Take a screenshot now and paste it here

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

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Databases questions