SELECT 
  work_year,
  -- Average salary for Medium companies
  ROUND(
    SUM(CASE WHEN company_size = 'M' THEN salary_in_usd END) / 
    SUM(CASE WHEN company_size = 'M' THEN 1 END), 
    2
  )/1000 AS avg_salary_M_kdollar,
  -- Average remote ratio for Medium companies
  ROUND(
    AVG(CASE WHEN company_size = 'M' THEN remote_ratio END), 
    2
  ) AS avg_remote_ratio_M,
  -- Average salary for Large companies
  ROUND(
    SUM(CASE WHEN company_size = 'L' THEN salary_in_usd END) / 
    SUM(CASE WHEN company_size = 'L' THEN 1 END), 
    2
  )/1000 AS avg_salary_L_kdollar,
  -- Average remote ratio for Large companies
  ROUND(
    AVG(CASE WHEN company_size = 'L' THEN remote_ratio END), 
    2
  ) AS avg_remote_ratio_L,
  -- Average salary for Small companies
  ROUND(
    SUM(CASE WHEN company_size = 'S' THEN salary_in_usd END) / 
    SUM(CASE WHEN company_size = 'S' THEN 1 END), 
    2
  )/1000 AS avg_salary_S_kdollar,
  -- Average remote ratio for Small companies
  ROUND(
    AVG(CASE WHEN company_size = 'S' THEN remote_ratio END), 
    2
  ) AS avg_remote_ratio_S
FROM 
  @kaggle.saurabhbadole_latest_data_science_job_salaries_2024.datascience_salaries_2024
GROUP BY 
  work_year
ORDER BY 
  work_year;