#*:1973;"Zatoichi's Conspiracy"
 
#*:1973;"Zatoichi's Conspiracy"
 
#Produce a table that lists every movie that has been rated, the rating that the movie got, and the name of the member that gave this rating.
 
#Produce a table that lists every movie that has been rated, the rating that the movie got, and the name of the member that gave this rating.
 +
#*select title, rating, name  from movie inner join rating on (movie.id = rating.movie) inner join member on (member.id = rating.member)
 +
#*:"Something's Gotta Give";4;"Doug"
 +
#*:"Zatoichi's Conspiracy";4;"Natalie"
 +
#*:"Zatoichi's Conspiracy";5;"Doug"
 +
#*:"Bruce Lee: A Warrior's Journey";2;"Natalie"
 +
#*:"Bruce Lee: A Warrior's Journey";5;"Doug"
 +
#*:"Star Trek: Deep Space Nine: Season 5";5;"Natalie"
 +
#*:"Star Trek: The Next Generation: Season 5";5;"Natalie"
 +
#*:"Star Wars: Ewok Adventures: Caravan of Courage / The Battle for Endor";1;"Natalie"
 +
#*:"Sesame Street: Cookie Monster's Best Bites";3;"Boomer"
 +
#*:"The Legend of Zelda: Ganon's Evil Tower";5;"Doug"
 +
#*:"Hello Kitty's Paradise";3;"Doug"
 +
#*:"Sesame Street: Elmo's Sing-Along Guessing Game";4;"Doug"
 +
#*:"Star Trek V: The Final Frontier";2;"Natalie"
 +
#*:"Star Wars: Episode II: Attack of the Clones";1;"Boomer"
 +
#*:"Star Trek: Nemesis";2;"Natalie"
 +
#*:"Star Wars: Episode VI: Return of the Jedi";5;"Boomer"
 +
#*:"Weekend at Bernie's";4;"Doug"
 +
#*:"Star Wars: Episode I: The Phantom Menace: Bonus Material";2;"Boomer"
 +
#*:"Star Trek: Insurrection";1;"Boomer"
 +
#*:"Donnie Darko: Director's Cut";5;"Doug"
 
#How many movies has member number 42 rated as 1, 2, 3, 4, and 5, respectively?
 
#How many movies has member number 42 rated as 1, 2, 3, 4, and 5, respectively?
 +
#*select rating, count (*) from rating where member =42 group by rating order by rating
 +
#*:1 was rated 1
 +
#*:0 were rated 2
 +
#*:2 were rated 3
 +
#*:3 were rated 4
 +
#*:4 were rated 5
 
#What is the average rating of movies that begin with the word “Star”?
 
#What is the average rating of movies that begin with the word “Star”?
 +
#*select avg (rating) from movie inner join rating on (movie.id = rating.movie)where title~'^Star'
 +
#*:average rating is 2.6 for movies beginning with Star
 
#Form your own query involving movies, ratings, and members, then
 
#Form your own query involving movies, ratings, and members, then
Unexpected non-MediaWiki exception encountered, of type "Error"
Error: Call to undefined function each() in /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php:374
Stack trace:
#0 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(480): _DiffEngine->_diag()
#1 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(291): _DiffEngine->_compareseq()
#2 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(175): _DiffEngine->diff_local()
#3 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(653): _DiffEngine->diff()
#4 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(820): Diff->__construct()
#5 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(1240): MappedDiff->__construct()
#6 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(1458): WordLevelDiff->__construct()
#7 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(952): TableDiffFormatter->_changed()
#8 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(924): DiffFormatter->_block()
#9 /apps/xmlpipedb/biodb/fall2013/includes/diff/DifferenceEngine.php(765): DiffFormatter->format()
#10 /apps/xmlpipedb/biodb/fall2013/includes/diff/DifferenceEngine.php(655): DifferenceEngine->generateDiffBody()
#11 /apps/xmlpipedb/biodb/fall2013/includes/diff/DifferenceEngine.php(593): DifferenceEngine->getDiffBody()
#12 /apps/xmlpipedb/biodb/fall2013/includes/diff/DifferenceEngine.php(566): DifferenceEngine->getDiff()
#13 /apps/xmlpipedb/biodb/fall2013/includes/diff/DifferenceEngine.php(409): DifferenceEngine->showDiff()
#14 /apps/xmlpipedb/biodb/fall2013/includes/Article.php(725): DifferenceEngine->showDiffPage()
#15 /apps/xmlpipedb/biodb/fall2013/includes/Article.php(478): Article->showDiffPage()
#16 /apps/xmlpipedb/biodb/fall2013/includes/actions/ViewAction.php(37): Article->view()
#17 /apps/xmlpipedb/biodb/fall2013/includes/Wiki.php(427): ViewAction->show()
#18 /apps/xmlpipedb/biodb/fall2013/includes/Wiki.php(304): MediaWiki->performAction()
#19 /apps/xmlpipedb/biodb/fall2013/includes/Wiki.php(536): MediaWiki->performRequest()
#20 /apps/xmlpipedb/biodb/fall2013/includes/Wiki.php(446): MediaWiki->main()
#21 /apps/xmlpipedb/biodb/fall2013/index.php(59): MediaWiki->run()
#22 {main}