Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
SQL Moving Rating Practice by Han Wang 20200720
drop table if exists HanW_movie; drop table if exists HanW_reviewer; drop table if exists HanW_rating; create table HanW_movie("mid" int, "title" text, "year" int, "director" text); create table HanW_reviewer("rid" int, "name" text); create table HanW_rating1("rid" int, "mid" int, "stars" int, "ratingdate" date); insert into HanW_movie("mid","title","year","director") values (101, 'Gone with the Wind', 1939, 'Victor Fleming'), (102, 'Star Wars', 1977, 'George Lucas'), (103, 'The Sound of Music', 1965, 'Robert Wise'), (104, 'E.T.', 1982, 'Steven Spielberg'), (105, 'Titanic', 1997, 'James Cameron'), (106, 'Snow White', 1937, null), (107, 'Avatar', 2009, 'James Cameron'), (108, 'Raiders of the Lost Ark', 1981, 'Steven Spielberg'); insert into HanW_reviewer("rid","name") values (201, 'Sarah Martinez'), (202, 'Daniel Lewis'), (203, 'Brittany Harris'), (204, 'Mike Anderson'), (205, 'Chris Jackson'), (206, 'Elizabeth Thomas'), (207, 'James Cameron'), (208, 'Ashley White'); insert into HanW_rating1("rid", "mid", "stars", "ratingdate") values (201, 101, 2, '2011-01-22'), (201, 101, 4, '2011-01-27'), (202, 106, 4, null), (203, 103, 2, '2011-01-20'), (203, 108, 4, '2011-01-12'), (203, 108, 2, '2011-01-30'), (204, 101, 3, '2011-01-09'), (205, 103, 3, '2011-01-27'), (205, 104, 2, '2011-01-22'), (205, 108, 4, null), (206, 107, 3, '2011-01-15'), (206, 106, 5, '2011-01-19'), (207, 107, 5, '2011-01-20'), (208, 104, 3, '2011-01-02'); -- HanW_movie("mid", "title", "year", "director"); -- HanW_reviewer("rid", "name"); -- HanW_rating1("rid", "mid", "stars", "ratingdate"); -- Q1 Find the titles of all movies directed by Steven Spielberg SELECT DISTINCT title FROM HanW_movie WHERE director in ('Steven Spielberg') ; --Q2 Q3 Q4 Q5 Q6 Q7 Q8
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
PostgreSQL Sandbox: Legitimate Resale
postgresql: working days
Select rows with no intersection on join table and check by date
Select rows only with values separated by a given interval from other ...
Game Play Analysis (511,512,534,550)
code1
Shortest "path" between two employees across companies
E2
Social Network SQL
hell
stackse - search stackoverflow differently
Please log in to post a comment.