Question: Write Queries to answer the following questions 1) Which actors have the last name Kilmer? (first name and last name) 2) How many unique actor

 Write Queries to answer the following questions 1) Which actors have

the last name Kilmer? (first name and last name) 2) How many

Write Queries to answer the following questions 1) Which actors have the last name Kilmer? (first name and last name) 2) How many unique actor last names are there? )Write a query that produces the last name, first name and email-address of all customers in the database, sorted by last name. Same as #3, but only list the customers who are inactive. (So that a manager could then email all inactive members a special deal to attract them back to the store). (active 0) Write a query that produces the last name, first name, address, district, and phone number for every customer in the customer table. (You don't need to include the city or postal code for this question) Same as #5, but only list the customers who are inactive, and include the city, country, postal code for each customer as well. Add 2 rows to the Film Database before working on this query. These new films are the only results you should get. 4) 5) 6) 7) Use this script to insert the new record. INSERT INTO sakila.film (film_id,title,description,release_year, language_id,rental_duration,rental_rate,length, replacement_cost,ra ting, special features) VALUES (1081, 1st Grade FBI Agent', 'An undercover FBI agent must pretend to be a 1st grade teacher to catch the bad guy',2814,2,5,4.99,123,20.99, PG-13, 'trailers), (1002, '2nd Grade DEA Agent', 'An undercover DEA agent must pretend to be a 2nd grade teacher to catch the bad guy',2815,3,4,5.99,132,16.99, 'PG-13','trailers')

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!