On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Function COUNT
Function AVG
Functions SUM, MAX, MIN
Review

Instruction

As you may already suspect, COUNT(DISTINCT expression) can be also used together with GROUP BY. Try it out in the exercise below.

Exercise

The rate per word is the price divided by the number of words. Show translator id together with number of distinct rates per word he used in his projects. Name the second column rates_no.

Stuck? Here's a hint!

To obtain the rate per word, use CAST(price AS numeric)/words.