Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Creating Basic SQL Reports in PostgreSQL

Introduction
Multiple metrics for a single object
Metrics for two groups
Ratios and percentages
Global vs. specific metrics
Summary
14. Summary

Instruction

It's time to wrap things up! Let's review the concepts we've covered in this part:

  1. We can calculate multiple metrics for a given business object using multiple aggregate functions in a single query.
  2. We can use COUNT(CASE WHEN ...) multiple times in a single query to count objects in multiple groups.
  3. When calculating percentages, remember to cast one of the counts to the decimal type. You can also use the ROUND() function, like this: 
    ROUND(count_shipped / count_all::decimal * 100, 2) AS shipped_ratio

All right, how about a quiz before we move on?

Exercise

Click Next exercise to continue.