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

SQL Practice Sample: Movie Database

Language: Layout:
absolute service time: 0,49 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
   title
1 E.T.
2 Raiders of the Lost Ark
   year stars
1 1939 4
2 1937 5
3 1937 4
4 2009 5
5 1981 4
6 1981 4
   year stars
1 2011 4
2 2011 4
3 2011 5
4 2011 5
   title
1 Star Wars
2 Titanic
   name
1 Chris Jackson
2 Daniel Lewis
   name
1 Chris Jackson
2 Daniel Lewis
   name title
1 Sarah Martinez Gone with the Wind
   title max
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
   title max_stars
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
   title rating_spread
1 Avatar 2
2 Gone with the Wind 2
3 Raiders of the Lost Ark 2
4 E.T. 1
5 Snow White 1
6 The Sound of Music 1
   title rating_spread
1 Avatar 2
2 Gone with the Wind 2
3 Raiders of the Lost Ark 2
4 E.T. 1
5 Snow White 1
6 The Sound of Music 1
   rate_diff
1 0,0555555555555555
   ?column?
1 0,0555555555555555
   ?column?
1 0,0555555555555555

    
                
Advertise here.