sql.sql

SELECT 
count(DISTINCT "employees"."id") as size,
"employees"."id"
    FROM
       "employees"
       LEFT OUTER JOIN
          "performance_level_adjustments"
          ON "performance_level_adjustments"."deleted_at" IS NULL
          AND "performance_level_adjustments"."employee_id" = "employees"."id"
          AND
          (
             effective_date <= '08-10-2020'
          )
       LEFT OUTER JOIN
          "salary_adjustments"
          ON "salary_adjustments"."deleted_at" IS NULL
          AND "salary_adjustments"."employee_id" = "employees"."id"
          AND "salary_adjustments"."state" = 'active'
       LEFT OUTER JOIN
          "performance_levels"
          ON "performance_levels"."id" = "employees"."linked_performance_level_id"
       LEFT OUTER JOIN
          "users"
          ON "users"."deleted_at" IS NULL
          AND "users"."employee_id" = "employees"."id"
       LEFT OUTER JOIN
          "employees" "direct_subordinates_employees"
          ON "direct_subordinates_employees"."type" IS NULL
          AND "direct_subordinates_employees"."immediate_supervisor_id" = "employees"."id"
          AND "direct_subordinates_employees"."archived" = FALSE
       LEFT OUTER JOIN
          "branches"
          ON "branches"."id" = "employees"."branch_id"
       LEFT OUTER JOIN
          "locations"
          ON "locations"."id" = "branches"."location_id"
       LEFT OUTER JOIN
          "positions"
          ON "positions"."deleted_at" IS NULL
          AND "positions"."id" = "employees"."position_id"
       LEFT OUTER JOIN
          "departments"
          ON "departments"."id" = "positions"."department_id"
       LEFT OUTER JOIN
          "employees" "immediate_supervisor"
          ON "employees"."immediate_supervisor_id" = "immediate_supervisor"."id"
    WHERE
       "employees"."type" IS NULL
       AND "employees"."company_id" = 73
       AND "employees"."archived" = FALSE
	  group by "employees"."id"