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

Movie Rating SQL Analysis Project

Language: Layout:
absolute service time: 0,45 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
   rid name
1 201 Sarah Martinez
2 202 Daniel Lewis
3 203 Brittany Harris
4 204 Mike Anderson
5 205 Chris Jackson
   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
   difference
1 0,0555555555555555
   title
1 E.T.
2 Raiders of the Lost Ark
   year
1 1937
2 1939
3 1981
4 2009
   title
1 Star Wars
2 Titanic
   name
1 Chris Jackson
2 Daniel Lewis
   name title stars ratingdate
1 Ashley White E.T. 3 02.01.2011 00:00:00
2 Brittany Harris Raiders of the Lost Ark 2 30.01.2011 00:00:00
3 Brittany Harris Raiders of the Lost Ark 4 12.01.2011 00:00:00
4 Brittany Harris The Sound of Music 2 20.01.2011 00:00:00
5 Chris Jackson E.T. 2 22.01.2011 00:00:00
6 Chris Jackson Raiders of the Lost Ark 4 NULL
7 Chris Jackson The Sound of Music 3 27.01.2011 00:00:00
8 Daniel Lewis Snow White 4 NULL
9 Elizabeth Thomas Avatar 3 15.01.2011 00:00:00
10 Elizabeth Thomas Snow White 5 19.01.2011 00:00:00
11 James Cameron Avatar 5 20.01.2011 00:00:00
12 Mike Anderson Gone with the Wind 3 09.01.2011 00:00:00
13 Sarah Martinez Gone with the Wind 2 22.01.2011 00:00:00
14 Sarah Martinez Gone with the Wind 4 27.01.2011 00:00:00
   name title
1 Sarah Martinez Gone with the Wind
   name title
1 Sarah Martinez Gone with the Wind
   title highest_num_star
1 Avatar 5
2 E.T. 3
3 Gone with the Wind 4
4 Raiders of the Lost Ark 4
5 Snow White 5
6 The Sound of Music 3