Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- insert into movies(movie_id, title, ranking, rating, year, votes, duration, oscars, budget)
- select distinct movie_id, title, ranking, rating, year, votes, duration, oscars, budget
- from denormalized;
- insert into languages(movie_id, language_name)
- select distinct movie_id, language_name
- from denormalized;
- insert into genres(movie_id, genres_name)
- select distinct movie_id, genres_name
- from denormalized;
- insert into countries(country_id, country_name)
- select distinct producer_country_id, producer_country_name
- from denormalized;
- select distinct director_country_id, director_country_name
- from denormalized;
- select distinct stat_country_id, star_country_name
- from denormalized;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement