Querying the dimensional model
Here it is! The schema reorganized using the dimensional model:
Let's try to run a query based on this schema. How about we try to find the number of minutes we ran in July, 2019?
We'll break this up in two steps. First, we'll get the total number of minutes recorded in the database. Second, we'll narrow down that query to week_id's from July, 2019.
Bu egzersiz
Database Design
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
SELECT
-- Select the sum of the duration of all runs
___
FROM
___;