I'm currently taking the online standford class on databases, If you could help me solve this sql problem I would greatly appreciate it. Sorry I'm a complete noob.
Table Movie:
mID | title | year | director
Table Rating
rID | mID | stars | ratingDate
Table Reviewer
rID | name
Remove all ratings where the movie's year is before 1970 or after 2000, and the rating is fewer than 4 stars.
Aucun commentaire:
Enregistrer un commentaire