CA 31 - Select Queries from DVD Rental database

Retrieve film titles and their rental rates. Use column aliases to rename title as "Movie Title" and rental_rate as "Rate". SELECT title AS "Movie Title",rental_rate AS "Rate"FROM film; Here,title is renamed into Movie Title amd rental_rate is renamed into Rate from film table and to show the output. List customer names and their email addresses. Alias first_name and last_name as "First Name" and "Last Name". SELECT first_name AS "First Name",last_name AS "Last Name",email FROM customer; Here, first_name is ranamed into First Name and last_name as Last Name and fetch the email from the customer table. Get a list of films sorted by rental rate in descending order. If two films have the same rental rate, sort them alphabetically by title. SELECT title,rental_rate FROM film ORDER BY rental_rate DESC,title ASC; Here, title and rental_rate to be fetch from film table and to order the rental_rate to descending order and title as ascending order. Retrieve actor names sorted by last name, then