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:

Exercise 14
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset