Lena Week 6 - Revision history

Lena: addded link to personal page

2013-10-04T04:50:58Z

addded link to personal page

Lena at 18:28, 3 October 2013

2013-10-03T18:28:31Z

Lena at 18:27, 3 October 2013

2013-10-03T18:27:32Z

Lena at 18:27, 3 October 2013

2013-10-03T18:27:18Z

Lena at 18:26, 3 October 2013

2013-10-03T18:26:24Z

Lena at 18:24, 3 October 2013

2013-10-03T18:24:46Z

Lena at 18:24, 3 October 2013

2013-10-03T18:24:07Z

← Older revision		Revision as of 04:50, 4 October 2013
Line 111:		Line 111:
	"Bruce Lee: A Warrior's Journey"		"Bruce Lee: A Warrior's Journey"

		+	[[user:Lena\|Lena Hunt]]
	[[Category:Journal Entry]]		[[Category:Journal Entry]]

← Older revision		Revision as of 18:28, 3 October 2013
Line 111:		Line 111:
	"Bruce Lee: A Warrior's Journey"		"Bruce Lee: A Warrior's Journey"

−	[[Category: Journal ~~Assignment~~]]	+	[[Category:Journal Entry]]

← Older revision		Revision as of 18:27, 3 October 2013
Line 111:		Line 111:
	"Bruce Lee: A Warrior's Journey"		"Bruce Lee: A Warrior's Journey"

−	[[Category: Journal ~~Entry~~]]	+	[[Category: Journal Assignment]]

← Older revision		Revision as of 18:27, 3 October 2013
Line 110:		Line 110:
	"Zatoichi's Conspiracy"		"Zatoichi's Conspiracy"
	"Bruce Lee: A Warrior's Journey"		"Bruce Lee: A Warrior's Journey"
		+
		+	[[Category: Journal Entry]]

← Older revision		Revision as of 18:26, 3 October 2013
Line 59:		Line 59:

	7.)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.		7.)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"
		+	"Pokemon Master Quest: Collector's Box: Quest 1";3;"Doug"
		+	"She's All That";1;"Doug"
		+	"She's All That";3;"Boomer"
		+	"Star Trek V: The Final Frontier: Bonus Material";2;"Boomer"
		+

	8.)How many movies has member number 42 rated as 1, 2, 3, 4, and 5, respectively?		8.)How many movies has member number 42 rated as 1, 2, 3, 4, and 5, respectively?

@@ Line 73: / Line 73: @@
 .) What are the titles of all of the movies that were rated a 5 by members?
-:'''select name, rating from movie inner join rating on (movie.id = rating.movie) inner join member on (member.id = rating.member) where rating =5 '''
+:'''select title, rating from movie inner join rating on (movie.id = rating.movie) inner join member on (member.id = rating.member) where rating =5 '''
+:
 :"Star Trek: The Next Generation: Season 5"