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 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
Get step-by-step solutions from verified subject matter experts
