Practice SELECT with Postgres Pagila

Write your query in the input box below.

Write a SQL query to select the first_name and last_name columns from the customer table, but display them as firstname and lastname in the result set.

Write a SQL query to select the first_name and last_name columns from the customer table, concatenating them together with a space in between. Display the result as fullname.

Write a SQL query to select all the languages from the language table, displaying the result as language.

Write a SQL query to get the rental_rate and replacement_cost of all the films from the film table, displaying the result as rentalrate and replacementcost.

Write a SQL query to list the first_name, last_name, and email of all the staff members from the staff table.

Write a SQL query to list all the stores from the store table. Select the correct number of stores from the options below.

Write a SQL query to list the payment_id, amount, and payment_date of all payments from the payment_p2022_04 table.

Write a SQL query to get the address of all the customers from the address table. Select only address, address2, district, city_id, and postal_code columns.