jeudi 20 août 2015

deleting data in a dataset

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