Gleis Week 6 - Revision history

Gleis at 05:04, 4 October 2013

2013-10-04T05:04:41Z

Gleis at 05:03, 4 October 2013

2013-10-04T05:03:53Z

Gleis at 04:09, 4 October 2013

2013-10-04T04:09:34Z

Gleis at 03:55, 4 October 2013

2013-10-04T03:55:11Z

Gleis at 03:54, 4 October 2013

2013-10-04T03:54:13Z

Gleis at 03:33, 4 October 2013

2013-10-04T03:33:25Z

Gleis at 03:26, 4 October 2013

2013-10-04T03:26:14Z

Gleis at 03:25, 4 October 2013

2013-10-04T03:25:38Z

Gleis at 03:16, 4 October 2013

2013-10-04T03:16:28Z

Gleis at 19:32, 3 October 2013

2013-10-03T19:32:30Z

← Older revision		Revision as of 05:04, 4 October 2013
Line 84:		Line 84:

	[[User:Gleis\|Gleis]] ([[User talk:Gleis\|talk]]) 22:03, 3 October 2013 (PDT)		[[User:Gleis\|Gleis]] ([[User talk:Gleis\|talk]]) 22:03, 3 October 2013 (PDT)
		+
		+	[[Category:Journal Entry]]

← Older revision		Revision as of 05:03, 4 October 2013
Line 82:		Line 82:
	#:*"My Own Private Idaho";1991		#:*"My Own Private Idaho";1991
	#:*"Twin Falls Idaho";1999		#:*"Twin Falls Idaho";1999
		+
		+	[[User:Gleis\|Gleis]] ([[User talk:Gleis\|talk]]) 22:03, 3 October 2013 (PDT)

@@ Line 78: / Line 78: @@
 #select avg (rating) from movie inner join rating on (movie.id = rating.movie) where title ~ '^Star'
 #*2.6000000000000000
+#Find movies with a title containing the word Idaho made after 1990. Make sure answer is in chronological order.

← Older revision		Revision as of 03:55, 4 October 2013
Line 78:		Line 78:
	#select avg (rating) from movie inner join rating on (movie.id = rating.movie) where title ~ '^Star'		#select avg (rating) from movie inner join rating on (movie.id = rating.movie) where title ~ '^Star'
	#*2.6000000000000000		#*2.6000000000000000
		+	#

← Older revision		Revision as of 03:54, 4 October 2013
Line 76:		Line 76:
	#*4;3		#*4;3
	#*5;4		#*5;4
		+	#select avg (rating) from movie inner join rating on (movie.id = rating.movie) where title ~ '^Star'
		+	#*2.6000000000000000

← Older revision		Revision as of 03:33, 4 October 2013
Line 71:		Line 71:
	#*"She's All That";3;"Boomer"		#*"She's All That";3;"Boomer"
	#*"Star Trek V: The Final Frontier: Bonus Material";2;"Boomer"		#*"Star Trek V: The Final Frontier: Bonus Material";2;"Boomer"
		+	#select rating, count(*) from rating where member = 42 group by rating order by rating -- answers in (rating; count)
		+	#*1;1
		+	#*3;2
		+	#*4;3
		+	#*5;4

@@ Line 66: / Line 66: @@
 #*"Star Wars: Episode I: The Phantom Menace: Bonus Material";2;"Boomer"
 #*"Star Trek: Insurrection";1;"Boomer"
-"Donnie Darko: Director's Cut";5;"Doug"
+#*"Donnie Darko: Director's Cut";5;"Doug"
-"Pokemon Master Quest: Collector's Box: Quest 1";3;"Doug"
+#*"Pokemon Master Quest: Collector's Box: Quest 1";3;"Doug"
-"She's All That";1;"Doug"
+#*"She's All That";1;"Doug"
-"She's All That";3;"Boomer"
+#*"She's All That";3;"Boomer"
-"Star Trek V: The Final Frontier: Bonus Material";2;"Boomer"
+#*"Star Trek V: The Final Frontier: Bonus Material";2;"Boomer"

← Older revision		Revision as of 03:25, 4 October 2013
Line 46:		Line 46:
	#*"The Legend of Zelda: Ganon's Evil Tower";5		#*"The Legend of Zelda: Ganon's Evil Tower";5
	#*"Donnie Darko: Director's Cut";5		#*"Donnie Darko: Director's Cut";5
		+	#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"

← Older revision		Revision as of 03:16, 4 October 2013
Line 41:		Line 41:
	#*1948;36		#*1948;36
	#*1949;41		#*1949;41
		+	#select title, rating from movie inner join rating on (movie.id = rating.movie) where member = 42 and rating = 5
		+	#*"Bruce Lee: A Warrior's Journey";5
		+	#*"Zatoichi's Conspiracy";5
		+	#*"The Legend of Zelda: Ganon's Evil Tower";5
		+	#*"Donnie Darko: Director's Cut";5

← Older revision		Revision as of 19:32, 3 October 2013
Line 30:		Line 30:
	#select count(*) from movie where title ~ '^Star'		#select count(*) from movie where title ~ '^Star'
	#*88		#*88
		+	#select year, count(*) from movie where year > 1939 and year < 1950 group by year order by year
		+	#*1940;34
		+	#*1941;33
		+	#*1942;33
		+	#*1943;33
		+	#*1944;36
		+	#*1945;37
		+	#*1946;39
		+	#*1947;37
		+	#*1948;36
		+	#*1949;41