Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- update STREAM
- inner join MOVIE on (STREAM.StreamId = MOVIE.MovieId)
- inner join CUSTOMER on (STREAM.StreamId = CUSTOMER.CustomerId)
- inner join COUNTRY on (CUSTOMER.Country = COUNTRY.Name)
- inner join REGION on (COUNTRY.RegionId = REGION.RegionId)
- set Charge = Charge + 1.5
- where REGION.Name = 'Europe' and MOVIE.Duration >= 180;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement