Advertisement
Guest User

Untitled

a guest
May 20th, 2019
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.32 KB | None | 0 0
  1. update STREAM
  2. inner join MOVIE on (STREAM.StreamId = MOVIE.MovieId)
  3. inner join CUSTOMER on (STREAM.StreamId = CUSTOMER.CustomerId)
  4. inner join COUNTRY on (CUSTOMER.Country = COUNTRY.Name)
  5. inner join REGION on (COUNTRY.RegionId = REGION.RegionId)
  6. set Charge = Charge + 1.5
  7. where REGION.Name = 'Europe' and MOVIE.Duration >= 180;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement