dbt MCP Server

{{ config(materialized='table') }} select department, count(*) as employee_count, avg(annual_salary) as avg_salary, min(annual_salary) as min_salary, max(annual_salary) as max_salary, sum(annual_salary) as total_payroll, current_timestamp as created_at from {{ ref('stg_employees') }} group by department order by avg_salary desc