MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table salary
(
  salaryID int,
  salary int,
  salaryYear int,
  industryName varchar(50)
 );
 
insert into salary
values(1,1000,2007,'business'),
      (2,500,2007,'ICT'),
      (3,1500,2008,'marketing'),
      (4,7000,2008,'accounting'),
      (5,600,2009,'logistic'),
      (6,100,2009,'business');
      

Records: 6  Duplicates: 0  Warnings: 0


SELECT s1.industryName, s2.min_salary, s2.salaryYear
  FROM salary s1
  JOIN  
  (
   SELECT MIN(salary) as min_salary, salaryYear
    FROM salary
   GROUP BY salaryYear
   ) s2
    ON s1.salary = s2.min_salary
   AND s1.salaryYear = s2.salaryYear;
   


industryName
min_salary
salaryYear


ICT
500
2007

marketing
1500
2008

business
100
2009