search

jlin47 / mp4

0 stars 0 forks source link

Questions to ask #1

Closed jlin47 closed 6 years ago

jlin47 commented 6 years ago

make a graph of male Vs. female actors. What kind of movies do they perform in? Among movies that show more female/male character/producers/writer, which has more revenue?

dasom1348 commented 6 years ago

The success of a movie depending on producers by gender:

jlin47 commented 6 years ago

GET THE INFO FOR FEMALE PRODUCERS

SELECT n.name, ci.role_id, person_id FROM cast_info ci JOIN name n ON n.id = ci.person_id WHERE role_id = "8" AND gender = "f"

dasom1348 commented 6 years ago

role_type id -> 3: producer, 4: writer, 8: director kind_id-> movie, tv series or not movie_id -> a specific movie get info movie, role_type id =8 and then join together

dasom1348 commented 6 years ago

+1 for using precise SQL queries (i.e. requesting only the columns you need, rather than requesting everything and filtering in R)

I think we don't need production year column in our sql! we can remove it!

dasom1348 commented 6 years ago

select movie_id from cast_info and then join by matching movie id in the best_movie table