Scribd
Upload
3 views1 page

Postgre SQL Assignment

Sql project

Uploaded by

aladesheriffdeen231
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
3 views1 page

Postgre SQL Assignment

Sql project

Uploaded by

aladesheriffdeen231
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

POSTGRE SQL ASSIGNMENT

1. How many payment transactions were greater than $5.00?


2. How many actors have a first name that starts with the letter P?
3. How many unique districts are our customers from?
4. Retrieve the list of names for those distinct districts from the previous question.
5. How many films have the word Truman somewhere in the title?
6. Create a table to organize our potential leads! We will have the following information: A
customer's first name, last name, email,sign-up date, and number of minutes spent on the dvd
rental site. You should also have some sort of id tracker for them. You have free reign on how
you want to create this table.
7. What customer has the highest customer ID number whose name starts with an ‘E’ and has
an address ID lower than 500?
8. Return the customer IDs of customers who have spent at least $110 with the staff member
who has an ID of 2.
9. How many films have a rating of R and a replacement cost between $5 and $15?
10. What is the maximum payment transaction done by the customer?

INFORMATION:
Write out the code, solution and send to the email address provided in your group.

Thanks
Program Lead - QA

You might also like