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.
Bu egzersiz
Introduction to Data Modeling in Snowflake
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
SELECT
-- Add attributes to select
employees.___,
trainings.___
FROM employees
-- Merge entities on common keys
___ trainings
ON ___ = ___
LIMIT 50;