The relations are ACTOR (actor id, first name, last name, last update) LANGUAGE (language id, name, last update) CATEGORY (category id, name, last update) FILM (film id, title, description, release year, language id, length, rating, last update) FILM ACTOR(actor id, film id, last update) FILM CATEGORY (film id, category id, last update) COMMENTS (review id, film id, reviewer name, comment, score, last update) (5 points) Retrieve the title of all the Movies in Italian and without actors with first name JOHN, ordered alphabetically This is my current SQL select film title from film join language on film language id language language id join film actor on film film id film actor film id join actor on film actor actor id actor actor id where lower(language name) 'italian' and actor first name 'JOHN' order by film title asc This is suppose to be my query ALABAMA DEVIL ARMAGEDDON LOST BENEATH RUSH BUCKET BROTHERHOOD CHISUM BEHAVIOR CONEHEADS SMOOCHY DANGEROUS UPTOWN DOUBLE WRATH ELIZABETH SHANE FIRE WOLVES GO PURPLE HARPER DYING HUNCHBACK IMPOSSIBLE LIFE TWISTED But I keep getting this as my query ALABAMA DEVIL ALABAMA DEVIL ALABAMA DEVIL ALABAMA DEVIL ALABAMA DEVIL ALABAMA DEVIL ALABAMA DEVIL ALABAMA DEVIL ALABAMA DEVIL ARMAGEDDON LOST ARMAGEDDON LOST ARMAGEDDON LOST ARMAGEDDON LOST ARMAGEDDON LOST ARMAGEDDON LOST ARMAGEDDON LOST BENEATH RUSH BENEATH RUSH BENEATH RUSH BENEATH RUSH BENEATH RUSH BENEATH RUSH BENEATH RUSH BUCKET BROTHERHOOD BUCKET BROTHERHOOD BUCKET BROTHERHOOD BUCKET BROTHERHOOD BUCKET BROTHERHOOD BUCKET BROTHERHOOD CHISUM BEHAVIOR CHISUM BEHAVIOR CHISUM BEHAVIOR CHISUM BEHAVIOR CONEHEADS SMOOCHY CONEHEADS SMOOCHY CONEHEADS SMOOCHY CONEHEADS SMOOCHY CONEHEADS SMOOCHY CONEHEADS SMOOCHY CONEHEADS SMOOCHY CONEHEADS SMOOCHY CONEHEADS SMOOCHY DANGEROUS UPTOWN DANGEROUS UPTOWN DANGEROUS UPTOWN DANGEROUS UPTOWN DANGEROUS UPTOWN DANGEROUS UPTOWN DANGEROUS UPTOWN DANGEROUS UPTOWN DOUBLE WRATH DOUBLE WRATH DOUBLE WRATH DOUBLE WRATH DOUBLE WRATH DOUBLE WRATH DOUBLE WRATH DOUBLE WRATH ELIZABETH SHANE ELIZABETH SHANE ELIZABETH SHANE FIRE WOLVES FIRE WOLVES FIRE WOLVES FIRE WOLVES FIRE WOLVES GO PURPLE GO PURPLE GO PURPLE HARPER DYING HARPER DYING HARPER DYING HARPER DYING HUNCHBACK IMPOSSIBLE HUNCHBACK IMPOSSIBLE JERSEY SASSY JERSEY SASSY JERSEY SASSY JERSEY SASSY JERSEY SASSY JERSEY SASSY JERSEY SASSY JERSEY SASSY LIFE TWISTED LIFE TWISTED LIFE TWISTED LIFE TWISTED LIFE TWISTED LIFE TWISTED LIFE TWISTED LIFE TWISTED

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

Question: The relations are: ACTOR (actor_id, first_name, last_name, last_update) LANGUAGE (language_id, name, last_update) CATEGORY (category_id, name, last_update) FILM (film_id, title, description, release_year, language_id, length, rating, last_update)

The relations are: ACTOR (actor_id, first_name, last_name, last_update) LANGUAGE (language_id, name, last_update) CATEGORY (category_id, name, last_update) FILM (film_id, title, description, release_year, language_id, length, rating, last_update) FILM_ACTOR(actor_id, film_id, last_update) FILM_CATEGORY (film_id, category_id, last_update) COMMENTS (review_id, film_id, reviewer_name, comment, score, last_update)

(5 points) Retrieve the title of all the Movies in Italian and without actors with first name JOHN, ordered alphabetically.

This is my current SQL

select film.title from film join language on film.language_id = language.language_id join film_actor on film.film_id = film_actor.film_id join actor on film_actor.actor_id = actor.actor_id where lower(language.name)= 'italian' and actor.first_name <> 'JOHN' order by film.title asc;

This is suppose to be my query

ALABAMA DEVIL

ARMAGEDDON LOST

BENEATH RUSH

BUCKET BROTHERHOOD

CHISUM BEHAVIOR

CONEHEADS SMOOCHY

DANGEROUS UPTOWN

DOUBLE WRATH

ELIZABETH SHANE

FIRE WOLVES

GO PURPLE

HARPER DYING

HUNCHBACK IMPOSSIBLE

LIFE TWISTED

But I keep getting this as my query

ALABAMA DEVIL

ARMAGEDDON LOST

BENEATH RUSH

BUCKET BROTHERHOOD

CHISUM BEHAVIOR

CONEHEADS SMOOCHY

DANGEROUS UPTOWN

DOUBLE WRATH

ELIZABETH SHANE

FIRE WOLVES

GO PURPLE

HARPER DYING

HUNCHBACK IMPOSSIBLE

JERSEY SASSY

LIFE TWISTED

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!

A movie can have 0 or more actors A movie can have 1 or more categories A movie has 1 and only one language Rating is one of these values: 'G','PG','PG-13','R', 'NC-17' People can comment about the...

I require these queries to be completed in MySQL please :) The relations are: ACTOR (actor_id, first_name, last_name, last_update) LANGUAGE (language_id, name, last_update) CATEGORY (category_id,...

Instructions: For this assignment you must submit a document file (in pdf, txt or doc format) with answers to the following questions. Consider the MOVIES relational database schema description: A...

Consider the MOVIES relational database schema description: A movie can have 0 or more actors A movie can have 1 or more categories A movie has 1 and only one language Rating is one of these values:...

PART 2 (35 points - 5 points each question) Write the following queries in relational algebra, using the schema provided for the MOVIES database. ACTOR (actor_id, first_name, last_name, last_update)...

Write the following queries in relational algebra, using the schema provided for the MOVIES database. ACTOR (actor_id, first_name, last_name, last_update) LANGUAGE (language_id, name, last_update)...

Using Relation Algebra ACTOR (actor_id, first_name, last_name, last_update) LANGUAGE (language_id, name, last_update) CATEGORY (category_id, name, last_update) FILM (film_id, title, description,...

Vendor Managed Inventory (VMI) is an important tool for Inventory Management. Discuss how this works and explain the benefits that accrue to both the supplier and the customer.

The reaction in eq. 7.17 occurs by an E2 mechanism (review eqs. 7.22 and 7.23). By what mechanism does the reaction in eq. 8.8 occur? H,sO CH3CHOH + HOCH2CH3 140%. CH,CHOC ethanol diethyl ether

work mode : This shows what is correct or incorrect for the work you have completed so far, It does not indleate completion. Croy Incorporated has the following projected sales for the next five...

Scenario: A Multi-national Corporation called The Globe has created a subsidiary called Thirst in an under-developed country called non-potable waters. This hosting country suffers from a severe...

1. Explain how business strategy affects HR strategy.

3. Assess the importance of information as a basis for decision making in the human resource planning process.

use appropriate techniques to produce accurate forecast supply and demand figures for an organisations human resources