MySQL 8.0

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

CREATE TABLE Company (
  idCompany SMALLINT NOT NULL,
  name_company VARCHAR(45) NOT NULL,
  abbr_company VARCHAR(3) NOT NULL,
  PRIMARY KEY (idCompany)
  );
  
 select * FRom Company;  
 
CREATE TABLE Employee (
  idEmployee TINYINT NOT NULL,
  name_Employee VARCHAR(45) NOT NULL,
  abbr_Employee VARCHAR(3) NOT NULL,
  PRIMARY KEY (idEmployee)
);

select * FRom Employee;
    
CREATE TABLE Automate (
  idAutomate SMALLINT NOT NULL,
  type_Automate VARCHAR(45) NOT NULL,
  idCompany SMALLINT NULL,
  PRIMARY KEY (idAutomate),
    FOREIGN KEY (idCompany)
    REFERENCES Company (idCompany)
    );
    
   
    select * FROM Automate;
    
    
CREATE TABLE Profit (
  idCodeTurnover INT NOT NULL,
  ddate DATE NOT NULL,
  idEmployee TINYINT NOT NULL,
  turnover INT NOT NULL,
  idCompany SMALLINT NULL,
  PRIMARY KEY (idCodeTurnover),
    FOREIGN KEY (idEmployee)
    REFERENCES Employee (idEmployee),
    FOREIGN KEY (idCompany)
    REFERENCES Company (idCompany)
);

INSERT INTO Company (idCompany, name_Company, abbr_Company) 
VALUES 
(1, 'Coffeeshop de Engel', 'CE'),
(2, 'Snackbar Vork', 'SV'),
(3, 'Kantine BV WSE', 'WSE'),
(4, 'Zwembad de Snip', 'ZS');

-- insert Employee 
INSERT INTO Employee (idEmployee, name_Employee, abbr_Employee)
VALUES
(1, 'Jan Hein', 'JHE'),
(2, 'Klaas Jansen', 'KJA'),
(3, 'Johan Bakker', 'JBA');

-- insert Automate
INSERT INTO Automate (idAutomate, type_Automate, idCompany)
VALUES
(21, 'F1_Racer', 1),
(23, 'Mega Crusher', 1),
(34, 'Photoplay', 1),
(22, 'F1 Racer', 2),
(37, 'Mega Crusher', 2),
(35, 'Photoplay', 3),
(36, 'Mega Crusher', 4),
(18, 'F1 Racer', 4);

INSERT INTO Profit (idCodeTurnover, ddate, idEmployee, turnover, idCompany)
VALUES
(1, '2011-01-11', 1, 1542, 1),
(2, '2011-02-11', 2, 1653, 1),
(3, '2011-03-11', 1, 1482, 1),
(4, '2011-04-11', 3, 2018, 1),
(5, '2011-05-11', 2, 1503, 1),
(6, '2011-05-12', 2, 2035, 2),
(7, '2011-03-01', 2, 837, 3),
(8, '2011-06-02', 2, 912, 3),
(9, '2011-09-01', 1, 799, 3),
(10, '2011-04-11', 3, 1387, 4);

select case when row_num=1 then abbr_Company else '' END companyname1,
 case when row_num=1 then name_Company else '' end companyname2, 
 ddate , 
 turnover , 
  name_Employee ,
 idCodeTurnover,
 row_num FROM(
SELECT abbr_Company, name_Company, ddate, turnover, name_Employee,idCodeTurnover,

ROW_NUMBER()OVER(PARTITION BY abbr_Company,name_Company ORDER BY turnover desc) AS row_num  
FROM Profit
INNER JOIN Employee ON Employee.idEmployee = Profit.idEmployee
INNER JOIN Company ON Profit.idCompany = Company.idCompany)X
ORDER BY abbr_Company,name_Company,row_num

companyname1	companyname2	ddate	turnover	name_Employee	idCodeTurnover	row_num
CE	Coffeeshop de Engel	2011-04-11	2018	Johan Bakker	4	1
		2011-02-11	1653	Klaas Jansen	2	2
		2011-01-11	1542	Jan Hein	1	3
		2011-05-11	1503	Klaas Jansen	5	4
		2011-03-11	1482	Jan Hein	3	5
SV	Snackbar Vork	2011-05-12	2035	Klaas Jansen	6	1
WSE	Kantine BV WSE	2011-06-02	912	Klaas Jansen	8	1
		2011-03-01	837	Klaas Jansen	7	2
		2011-09-01	799	Jan Hein	9	3
ZS	Zwembad de Snip	2011-04-11	1387	Johan Bakker	10	1