
DB-TASK using dvdrental database
Hi everyoune! Retrieve film titles and their rental rates. Use column aliases to rename title as "Movie Title" and rental_rate as "Rate". this query selects title and rental_rate from table film and renames the columns as Movie_Title and Rate. SELECT title AS "Movie Title", rental_rate AS "Rate" FROM film; List customer names and their email addresses. Alias first_name and last_name as "First Name" and "Last Name". This query selects first name, last name, and emailfrom customer table and then renamed first_name as First Name and last_name as Last Name. SELECT first_name AS "First Name", last_name AS "Last Name", email FROM customer; 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 we select films sorted by highest rental rate first, and if same rate, sorted alphabetically by title. Retrieve actor names sorted by last na
Continue reading on Dev.to
Opens in a new tab



