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.to0
0Related
Hacker News
$500 GPU outperforms Claude Sonnet on coding benchmarks
Discussed on Hacker News with 377 points and 217 comments.
377
217Hacker News
Whistler: Live eBPF Programming from the Common Lisp REPL
Discussed on Hacker News with 115 points and 13 comments.
115
13Hacker News
Anthropic Subprocessor Changes
Discussed on Hacker News with 98 points and 44 comments.
98
44Liked this? Start your own feed.
Your own feed is waiting.
Comment
Sign in to join the discussion.
Loading comments…