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, f