In the following problems, use the in operator whenever you can Movie mID title year director 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 107 Avatar 2009 James Cameron 108 Raiders of the Lost Ark 1981 Steven Spielberg Reviewer rID name 201 Sarah Martinez 202 Daniel Lewis 203 Brittany Harris 204 Mike Anderson 205 Chris Jackson 206 Elizabeth Thomas 207 James Cameron 208 Ashley White Rating rID mID stars ratingDate 201 101 2 2011 01 22 201 101 4 2011 01 27 202 106 4 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 206 107 3 2011 01 15 206 106 5 2011 01 19 207 107 5 2011 01 20 208 104 3 2011 01 02 1 Return all reviewer names and movie names together in a single list, alphabetized (Sorting by the first name of the reviewer and first word in the title is fine no need for special processing on last names or removing The ) 2 Find the titles of all movies not reviewed by Chris Jackson

The Answer is in the image, click to view ...

Question: In the following problems, use the in operator whenever you can: Movie mID title year director 101 Gone with the Wind 1939 Victor Fleming

In the following problems, use the " in" operator whenever you can:

Movie

mID	title	year	director
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
107	Avatar	2009	James Cameron
108	Raiders of the Lost Ark	1981	Steven Spielberg

Reviewer

rID	name
201	Sarah Martinez
202	Daniel Lewis
203	Brittany Harris
204	Mike Anderson
205	Chris Jackson
206	Elizabeth Thomas
207	James Cameron
208	Ashley White

Rating

rID	mID	stars	ratingDate
201	101	2	2011-01-22
201	101	4	2011-01-27
202	106	4
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
206	107	3	2011-01-15
206	106	5	2011-01-19
207	107	5	2011-01-20
208	104	3	2011-01-02

1. Return all reviewer names and movie names together in a single list, alphabetized. (Sorting by the first name of the reviewer and first word in the title is fine; no need for special processing on last names or removing "The".)

2. Find the titles of all movies not reviewed by Chris Jackson.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

NA SQL Movie-Rating Query Exercises Bomage Exercise dun Mar 31, 2021 13:31 EDT Youve started a new movie-rating website, and you've been collecting data on reviewers ratings of various movies....

This is the given sql /* Delete the tables if they already exist */ drop table if exists Movie; drop table if exists Reviewer; drop table if exists Rating; /* Create the schema for our tables */...

Consider the following database schema and write queries to solve the problems: Movie (mID, title, year, director): each movie has an ID number (MID), a title, a release year, and a director Reviewer...

1 Delete the tables if they already exist 2drop table if exists Movie; 3drop table if exists Reviewer; drop table if exists Rating; Create the schema for our tables*/ create 6 7 . table Movie(mID...

Help can you please show the code and output of the solution too. (make it as basic as possible) SQL language Thank you very much Thank you very much name Movie Reviewer mID title year director rID...

QUESTION: Constraints and Referencial Integrity Further modify one or more of your CREATE TABLE statements to include the following referential integrity constraints and policies. 1. Referential...

note: it's written in mysql. Movie ( mID, title, year, director ) English: There is a movie with ID number mID, a title, a release year, and a director. Reviewer ( rID, name ) English: The reviewer...

I need help accomplishing task 6 and I have pasted my sql code below, but I cannot get those statments to work properly. Im not sure how to set up the foreign keys in my creat statements and would...

MYSQL: Write the following errors in plain English. If there is a cascading change, describe the change in plain English. Code: /* Delete the tables if they already exist */ drop table if exists...

I need to modify my CREATE TABLE statements to get proper error message from the following statements I have my create table statements below. I just need help with 14 to give me an error message for...

Refer to Exercise 10.83. Suppose you wish to estimate the difference in mean times to absorption correct to within 1 minute with probability approximately equal to .95. a. Approximately how large a...

Suppose that xn R. a) Prove that {xn} is bounded if and only if there is a C > 0 such that |xn|

Client One Destiny, age 26, is single. But she is dating and preparing to get engaged to her girlfriend, Rosa. She will need about $5,000 for an engagement ring soon. And she will need...

The future earnings, dividends, and common stock price of Callahan Technologies Inc. are expected to grow 8% per year. Callahan's common stock currently sells for $23.25 per share; its last dividend...

6. Calculate the total savings by subtracting the training costs from benefits (operational results).

3. Determine the change in performance after eliminating other potential influences on training results.

1. Identify outcomes (e.g., quality, accidents).