Select Queries from DVD Rental database Pt-1

#sql #postgres #database #tutorial

first, Download the tar file https://github.com/syedjaferk/postgres_sample_database/blob/main/dvd_rental/dvdrental.tar
using the above link
then open pgAdmin4 Login to your postgres then upload the downloaded database
create a new database called dvdrental using the cmd
CREATE DATABASE dvdrental;

-To check if your database has been uploaded use this cmd \dt

SELECT Query

Basic SELECT Statement SELECT first_name FROM customer; use the cmd to display all name in database

1) Use column aliases to rename title as "Movie Title" and rental_rate as "Rate"

cmd: SELECT title AS "Movie Title", rental_rate AS "Rate"
FROM film;

2) List customer names and their email addresses. Alias first_name and last_name as "First Name" and "Last Name"

cmd: SELECT first_name AS "First Name", last_name AS "Last Name", email FROM customer;

3) 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.

cmd: SELECT title, rental_rate FROM film ORDER BY rental_rate DESC, title ASC;

4) Retrieve actor names sorted by last name, then first name.

cmd: ORDER BY last_name ASC, first_name ASC;