Advertisement
Guest User

Untitled

a guest
May 21st, 2019
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. insert into movies(movie_id, title, ranking, rating, year, votes, duration, oscars, budget)
  2. select distinct movie_id, title, ranking, rating, year, votes, duration, oscars, budget
  3. from denormalized;
  4.  
  5. insert into languages(movie_id, language_name)
  6. select distinct movie_id, language_name
  7. from denormalized;
  8.  
  9. insert into genres(movie_id, genres_name)
  10. select distinct movie_id, genres_name
  11. from denormalized;
  12.  
  13. insert into countries(country_id, country_name)
  14. select distinct producer_country_id, producer_country_name
  15. from denormalized;
  16.  
  17.  
  18. select distinct director_country_id, director_country_name
  19. from denormalized;
  20.  
  21.  
  22.  
  23. select distinct stat_country_id, star_country_name
  24. from denormalized;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement