forestheims/backend-sql-aggregates

DVD Rental Aggregates

Getting Started

Use this template to get started.

Learning Objectives

• Read an ERD for an existing schema
• Write a SELECT query that returns a COUNT of rows
• Write a SELECT query that returns the SUM of a set of rows for a numeric field
• Write a SELECT query that returns the AVG of a set of rows for a numeric field
• Write a SELECT query that returns a list of rows using GROUP BY
• Write a SELECT query that returns a sorted list of rows using ORDER BY
• Write a SELECT query that utilizes a ROLLUP aggregation
• Write a SELECT query that utilizes a CUBE aggregation
• Write a SELECT query that utilizes a RANK aggregation
• Write a JOIN query to return relational data in two SQL tables
• Write a SELECT query that JOINs two SQL tables via a junction table

Description

Using the DVD Rental Data provided by the PostgreSQL Tutorial you are going to perform a series of queries utilizing both joins & aggregates.

You only need to edit the exercise-*.sql files NOT the tests.

To validate your queries, run npm run test.

Acceptance Criteria

• All tests pass

Rubric

Task	Points
All tests pass	10