CREATE TABLE movie (mid NUMBER, title CLOB, year NUMBER, director CLOB)
CREATE TABLE rating (rid NUMBER, mid NUMBER, stars NUMBER, ratingdate TIME)
CREATE TABLE reviewer (rid NUMBER, name CLOB)

Return all reviewer names and movie names together in a single list.
SELECT name FROM reviewer UNION SELECT title FROM movie
SELECT "name" FROM "reviewer" UNION SELECT "title" FROM "movie"