Exercise 14
The two metrics come from the same fact table, so in the SQL view there is just one SELECT
statement with both count(1)
and sum(a11.SalesAmount)
.
See the image for results:
The two metrics come from the same fact table, so in the SQL view there is just one SELECT
statement with both count(1)
and sum(a11.SalesAmount)
.
See the image for results: