Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Movie Rating SQL Analysis Conducted by Miranda Zhao

Language: Layout:
absolute service time: 0,61 sec   
edit mode |  history  | discussion
   mid title year director
1 101 Gone with the Wind 1939 Victor Fleming
2 102 Star Wars 1977 George Lucas
3 103 The Sound of Music 1965 Robert Wise
4 104 E.T. 1982 Steven Spielberg
5 105 Titanic 1997 James Cameron
6 106 Snow White 1937 NULL
7 107 Avatar 2009 James Cameron
8 108 Raiders of the Lost Ark 1981 Steven Spielberg
   rid name
1 201 Sarah Martinez
2 202 Daniel Lewis
3 203 Brittany Harris
4 204 Mike Anderson
5 205 Chris Jackson
6 206 Elizabeth Thomas
7 207 James Cameron
8 208 Ashley White
   rid mid stars ratingdate
1 201 101 2 22.01.2011 00:00:00
2 201 101 4 27.01.2011 00:00:00
3 202 106 4 NULL
4 203 103 2 20.01.2011 00:00:00
5 203 108 4 12.01.2011 00:00:00
6 203 108 2 30.01.2011 00:00:00
7 204 101 3 09.01.2011 00:00:00
8 205 103 3 27.01.2011 00:00:00
9 205 104 2 22.01.2011 00:00:00
10 205 108 4 NULL
11 206 107 3 15.01.2011 00:00:00
12 206 106 5 19.01.2011 00:00:00
13 207 107 5 20.01.2011 00:00:00
14 208 104 3 02.01.2011 00:00:00
   rid1 rid2 rid1name rid2name
1 201 204 Sarah Martinez Mike Anderson
2 202 206 Daniel Lewis Elizabeth Thomas
3 203 205 Brittany Harris Chris Jackson
4 205 208 Chris Jackson Ashley White
5 206 207 Elizabeth Thomas James Cameron
   name name
1 Ashley White Chris Jackson
2 Brittany Harris Chris Jackson
3 Daniel Lewis Elizabeth Thomas
4 Elizabeth Thomas James Cameron
5 Mike Anderson Sarah Martinez
   name title stars
1 Sarah Martinez Gone with the Wind 2
2 Brittany Harris Raiders of the Lost Ark 2
3 Brittany Harris The Sound of Music 2
4 Chris Jackson E.T. 2
   name mid title stars movie_rank
1 Ashley White 104 E.T. 3 1
2 Brittany Harris 108 Raiders of the Lost Ark 2 1
3 Chris Jackson 104 E.T. 2 1
4 Daniel Lewis 106 Snow White 4 1
5 Elizabeth Thomas 107 Avatar 3 1
6 James Cameron 107 Avatar 5 1
7 Mike Anderson 101 Gone with the Wind 3 1
8 Sarah Martinez 101 Gone with the Wind 2 1
   name mid title stars movie_rank
1 Sarah Martinez 101 Gone with the Wind 2 1
2 Brittany Harris 103 The Sound of Music 2 1
3 Chris Jackson 104 E.T. 2 1
4 Daniel Lewis 106 Snow White 4 1
5 Elizabeth Thomas 107 Avatar 3 1
6 Brittany Harris 108 Raiders of the Lost Ark 2 1
   name mid title stars movie_rank
1 Sarah Martinez 101 Gone with the Wind 2 1
2 Brittany Harris 103 The Sound of Music 2 1
3 Chris Jackson 104 E.T. 2 1
4 Daniel Lewis 106 Snow White 4 1
5 Elizabeth Thomas 107 Avatar 3 1
6 Brittany Harris 108 Raiders of the Lost Ark 2 1
   title avg
1 Snow White 4,5000
2 Avatar 4
3 Raiders of the Lost Ark 3,3333333333333333
4 Gone with the Wind 3
5 E.T. 2,5000
6 The Sound of Music 2,5000
   title mid avg_movie_rating
1 Avatar 107 4
2 Snow White 106 4
3 Gone with the Wind 101 3
4 Raiders of the Lost Ark 108 3
5 E.T. 104 2
6 The Sound of Music 103 2
   name
1 Chris Jackson
2 Brittany Harris
   name rating_times
1 Chris Jackson 3
2 Brittany Harris 3
   name rating_times
1 Chris Jackson 3
2 Brittany Harris 3
   mid mid title director
1 107 105 Avatar James Cameron
2 105 107 Titanic James Cameron
3 104 108 E.T. Steven Spielberg
4 108 104 Raiders of the Lost Ark Steven Spielberg
   mid director direct_times
1 105 James Cameron 2
2 107 James Cameron 2
3 104 Steven Spielberg 2
4 108 Steven Spielberg 2
   mid mid director director
1 101 101 Victor Fleming Victor Fleming
2 102 102 George Lucas George Lucas
3 103 103 Robert Wise Robert Wise
4 104 108 Steven Spielberg Steven Spielberg
5 104 104 Steven Spielberg Steven Spielberg
6 105 107 James Cameron James Cameron
7 105 105 James Cameron James Cameron
8 106 106 NULL NULL
9 107 107 James Cameron James Cameron
10 107 105 James Cameron James Cameron
11 108 108 Steven Spielberg Steven Spielberg
12 108 104 Steven Spielberg Steven Spielberg
   mid director direct_times1 direct_times2
1 105 James Cameron 2 2
2 108 Steven Spielberg 2 2
3 104 Steven Spielberg 2 2
4 107 James Cameron 2 2
   mid director direct_times1 direct_times2
1 107 James Cameron 2 2
2 105 James Cameron 2 2
3 108 Steven Spielberg 2 2
4 104 Steven Spielberg 2 2
   mid director direct_times1 direct_times2
1 105 James Cameron 2 2
2 107 James Cameron 2 2
3 104 Steven Spielberg 2 2
4 108 Steven Spielberg 2 2
   mid title avg_stars
1 106 Snow White 4
2 107 Avatar 4
   mid title avg_rating
1 106 Snow White 4
2 107 Avatar 4
   mid avg_stars
1 106 4,5000
   mid avg_stars
1 106 4
2 107 4
   mid title director stars row_num
1 107 Avatar James Cameron 5 1
2 106 Snow White NULL 5 1
3 108 Raiders of the Lost Ark Steven Spielberg 4 1
4 101 Gone with the Wind Victor Fleming 4 1
5 103 The Sound of Music Robert Wise 3 1
   director title stars
1 James Cameron Avatar 5
2 NULL Snow White 5
3 Robert Wise The Sound of Music 3
4 Steven Spielberg Raiders of the Lost Ark 4
5 Victor Fleming Gone with the Wind 4
   title
1 E.T.
2 Gone with the Wind
3 Avatar
4 The Sound of Music
5 Snow White
6 Raiders of the Lost Ark
   title
1 Gone with the Wind
2 Star Wars
3 Titanic
4 Snow White
5 Avatar
   title
1 Gone with the Wind
2 Star Wars
3 Titanic
4 Snow White
5 Avatar