Lesson 1 of 10

Choose the level of detail and prevent double counting

Secure a KPI before a join between multiple 1:N relationships.

28 minSQL Data Analyst

By the end of this lesson

  • Define the level of detail of a table and a result
  • Identify a relationship that multiplies the lines
  • Pre-aggregate before a join

SQL Analyst

Continue with the right access

“Choose the level of detail and prevent double counting” is included from SQL Analyst.

30 free days of SQL Pro on registration, subject to the 31 remaining places. No card or automatic renewal.

Create my Discovery spaceI already have an account
After signing in, you will return directly to this activity.
Choose the level of detail and prevent double counting — SQL.tn