1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Data Modeling in Snowflake
Connected

Exercise

Retrieving data from ER model

The HR department has launched an initiative to closely monitor employees training progress within the 'Operations' department. They aim to identify employees who have exceeded the average training score threshold, indicating successful completion of their training programs.

Your task is to use the ER model to build a report by joining relevant entities and applying necessary filters to get the results fast and efficiently.

Instructions 1/3

undefined XP
    1
    2
    3
  • Write a query to select the employee_id from the employees entity and the avg_training_score attribute from the trainings entity.
  • Merge the employees and trainings entities based ON their shared employee_id key.