/backend-sql-aggregates

Primary LanguageJavaScript

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