Method: FactMetrics::AverageConfig#sql

Defined in:
lib/fact_metrics/average_config.rb

#sqlObject



23
24
25
26
27
28
29
# File 'lib/fact_metrics/average_config.rb', line 23

def sql
  <<~SQL
    CASE WHEN count(*) != 0 THEN
      AVG(#{field_name})
    END AS #{sql_result_name}
  SQL
end