Databricks Genie 스페이스 큐레이션 가이드: 정확한 비즈니스 답변을 위한 6단계

COUNTIF(compensation.Raise_Amount > 0) / COUNT(DISTINCT employees.Employee_ID)

CREATE FUNCTION calculate_flight_risk_rate()
RETURNS TABLE
LANGUAGE SQL
AS
SELECT
  'employees' AS state,
  ROUND(AVG(employees.Retention_Rate), 2) AS Flight_Risk_Rate
FROM bakehouse_hr_hr_data.employees
ORDER BY Flight_Risk_Rate DESC;