Skip to content
Dev.to

Select Queries from DVD Rental database

Film titles and rental rates (Aliased) SELECT title AS "Movie Title", rental_rate AS "Rate" FROM film; Customer names and emails (Aliased) SELECT first_name AS "First Name", last_name AS "Last Name", email FROM customer; Films sorted by rental rate (DESC) and title (ASC) SELECT * FROM film ORDER BY rental_rate DESC, title ASC; Actor names sorted by last name, then first name SELECT first_name, last_name FROM actor ORDER BY last_name, first_name; Unique replacement costs SELECT DISTINCT replaceme
Read original on dev.to
0
0

Comment

Sign in to join the discussion.

Loading comments…

Related

Liked this? Start your own feed.

Your own feed is waiting.
0
0