What are the names of the movies that was reviewed by brittany harris?
select distinct t2.title from rating as t1 join movie as t2 on t1.mid = t2.mid join reviewer as t3 on t1.rid = t3.rid where t3.name = 'Brittany Harris'
What are the names of movies made after 2000?
select distinct t2.title from rating as t1 join movie as t2 on t1.mid = t2.mid join reviewer as t3 on t1.rid = t3.rid where t2.year > 2000
How many rating  stars did Avatar had?
select t1.stars from rating as t1 join movie as t2 on t1.mid = t2.mid where t2.title = 'Avatar'