Ksherbina Week 6 - Revision history

Ksherbina: /* Movies from Text Files to Tables */ Added a colon after each appearance of the word "Correction"

2013-10-15T02:22:30Z

‎Movies from Text Files to Tables: Added a colon after each appearance of the word "Correction"

2013-10-15T02:21:34Z

‎Movies from Text Files to Tables: Made a correction to the code and output for #8.

2013-10-15T01:13:28Z

Correction of code and output for #5.

2013-10-13T22:07:57Z

Fixed #3 by using nowiki tags as Dondi suggested.

2013-10-09T07:17:53Z

Added categories.

2013-10-04T05:02:12Z

‎Movies from Text Files to Tables: Added answer to question 10.

2013-10-04T04:49:20Z

‎Movies from Text Files to Tables: Added code and output for question 9.

2013-10-04T02:45:19Z

‎Movies from Text Files to Tables: Added comment regarding 9.

2013-10-04T02:39:23Z

Modified description of code for question 8.

2013-10-04T02:38:18Z

Added code and output to answer question 8.

@@ Line 57: / Line 57: @@
-'''Correction'''
+'''Correction:'''
 :Code:
   select year, count(*) from movie where year > 1939 and year < 1950 group by year
@@ Line 141: / Line 141: @@
-'''Correction'''
+'''Correction:'''
 :Code:

← Older revision		Revision as of 02:21, 15 October 2013
Line 140:		Line 140:
	:Output:		:Output:
	4		4
		+
		+	'''Correction'''
		+
		+	:Code:
		+	select rating, count(*) from rating where member = '42' group by rating
		+
		+	:Output:
		+	5;4
		+	1;1
		+	4;3
		+	3;2

	9. Code:		9. Code:

← Older revision		Revision as of 01:13, 15 October 2013
Line 56:		Line 56:
	:Output:		:Output:
	359		359
		+
		+	'''Correction'''
		+	:Code:
		+	select year, count(*) from movie where year > 1939 and year < 1950 group by year
		+
		+	:Output:
		+	1942;33
		+	1948;36
		+	1943;33
		+	1946;39
		+	1949;41
		+	1945;37
		+	1947;37
		+	1940;34
		+	1944;36
		+	1941;33

	6. Code:		6. Code:

@@ Line 31: / Line 31: @@
 . Code:
-  select * from movie where title ~ ''''
+  select * from movie where title ~ <nowiki>''''</nowiki>
 :Output:

← Older revision		Revision as of 07:17, 9 October 2013
Line 137:		Line 137:
	:Answer to the query:		:Answer to the query:
	6		6
		+
		+	[[Category:Journal Entry]]
		+	[[Category:Individual Homework]]

← Older revision		Revision as of 05:02, 4 October 2013
Line 130:		Line 130:
	:Output:		:Output:
	2.6000000000000000		2.6000000000000000
		+
		+	10. Query in plain English: How many movies were not rated a 1 or 2 by member 6 or member 8?
		+	:Query in SQL:
		+	select count(*) from movie inner join rating on (movie.id = rating.movie) where (member = '6' or member = '8') and not (rating = '1' or rating = '2')
		+
		+	:Answer to the query:
		+	6

← Older revision		Revision as of 04:49, 4 October 2013
Line 125:		Line 125:
	4		4

−	~~<!--~~ 9. select ~~average~~(rating) from movie inner join rating on (movie.id = rating.movie) where title ~ '^Star ' ~~-->~~	+	9. Code:
		+	select avg(rating) from movie inner join rating on (movie.id = rating.movie) where title ~ '^Star '
		+
		+	:Output:
		+	2.6000000000000000

← Older revision		Revision as of 02:45, 4 October 2013
Line 124:		Line 124:
	:Output:		:Output:
	4		4
		+
		+	<!-- 9. select average(rating) from movie inner join rating on (movie.id = rating.movie) where title ~ '^Star ' -->

@@ Line 95: / Line 95: @@
   "Star Trek V: The Final Frontier: Bonus Material";2;"Boomer"
-. Code to count how many movies member 42 gave a rating of 1:
+. Code to count for how many movies member 42 gave a rating of 1:
   select count(*) from rating where member = '42' and rating = '1'
@@ Line 101: / Line 101: @@
-:Code to count how many movies member 42 gave a rating of 2:
+:Code to count for how many movies member 42 gave a rating of 2:
   select count(*) from rating where member = '42' and rating = '2'
@@ Line 107: / Line 107: @@
-:Code to count how many movies member 42 gave a rating of 3:
+:Code to count for how many movies member 42 gave a rating of 3:
   select count(*) from rating where member = '42' and rating = '3'
@@ Line 113: / Line 113: @@
-:Code to count how many movies member 42 gave a rating of 4:
+:Code to count for how many movies member 42 gave a rating of 4:
   select count(*) from rating where member = '42' and rating = '4'
@@ Line 119: / Line 119: @@
-:Code to count how many movies member 42 gave a rating of 5:
+:Code to count for how many movies member 42 gave a rating of 5:
   select count(*) from rating where member = '42' and rating = '5'
 :Output:

← Older revision		Revision as of 02:38, 4 October 2013
Line 94:		Line 94:
	"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"
		+
		+	8. Code to count how many movies member 42 gave a rating of 1:
		+	select count(*) from rating where member = '42' and rating = '1'
		+
		+	:Output:
		+	1
		+
		+	:Code to count how many movies member 42 gave a rating of 2:
		+	select count(*) from rating where member = '42' and rating = '2'
		+
		+	:Output:
		+	0
		+
		+	:Code to count how many movies member 42 gave a rating of 3:
		+	select count(*) from rating where member = '42' and rating = '3'
		+
		+	:Output:
		+	2
		+
		+	:Code to count how many movies member 42 gave a rating of 4:
		+	select count(*) from rating where member = '42' and rating = '4'
		+
		+	:Output:
		+	3
		+
		+	:Code to count how many movies member 42 gave a rating of 5:
		+	select count(*) from rating where member = '42' and rating = '5'
		+
		+	:Output:
		+	4