Need MySql commands for Use a UNION statement Display the address ID, address, and district from the address table where the district is California or Alberta Display the address ID, address, and district only from the address table where the address contains Jol Display the language ID and name from the language table and the film ID from the film table Display all languages whether they have an associated film or not Order results by language ID in ascending order List the actor ID, their first and last name of all actors and a count of the films they have done Result set should be sorted descending by the actors first name and new column should be named FilmCount The objective you are to show here is how to use a subquery in an expression Show the customer ID, their first and last name, and the date of their last payment (name this column RecentPayment) of all those that are inactive customers sorted descending by last name and then ascending by first name The objective you are to show here is how to use a subquery in an expression List the film ID, title, and description from the film text table for those films that have Zero Cage as the actor Order your results set by the film description The objective you are to show here is how to use a subquery in a filter

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

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 24, 2024

Need MySql commands for

Use a UNION statement. Display the address ID, address, and district from the address table where the district is California or Alberta. Display the address ID, address, and district only from the address table where the address contains Jol.
Display the language ID and name from the language table and the film ID from the film table. Display all languages whether they have an associated film or not. Order results by language ID in ascending order.
List the actor ID, their first and last name of all actors and a count of the films they have done. Result set should be sorted descending by the actors first name and new column should be named FilmCount. The objective you are to show here is how to use a subquery in an expression.

Show the customer ID, their first and last name, and the date of their last payment (name this column RecentPayment) of all those that are inactive customers sorted descending by last name and then ascending by first name. The objective you are to show here is how to use a subquery in an expression.
List the film ID, title, and description from the film_text table for those films that have Zero Cage as the actor. Order your results set by the film description. The objective you are to show here is how to use a subquery in a filter.