MySQL 5.7

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

select version();


version()


5.7.28


CREATE TABLE test_tab
(
  first_name VARCHAR (25) NOT NULL,
  last_name  VARCHAR (25) NOT NULL,
  soft_name  VARCHAR (25) NOT NULL,
  soft_hours VARCHAR (25) NOT NULL
);

INSERT INTO test_tab VALUES ('Max', 'Huber', 'Word',  '25h');
INSERT INTO test_tab VALUES ('Max', 'Huber', 'Excel', '15h');

INSERT INTO test_tab VALUES ('Felix', 'TheCat', 'Outlook', '35h');
INSERT INTO test_tab VALUES ('Felix', 'TheCat', 'Word',  '25h');
INSERT INTO test_tab VALUES ('Felix', 'TheCat', 'Excel', '15h');

INSERT INTO test_tab VALUES ('Donald', 'Duck', 'Excel', '20h');
INSERT INTO test_tab VALUES ('Donald', 'Duck', 'Word',  '8h');
INSERT INTO test_tab VALUES ('Donald', 'Duck', 'Outlook', '3h');


SELECT * FROM test_tab
ORDER BY last_name;


first_name
last_name
soft_name
soft_hours


Donald
Duck
Excel
20h

Donald
Duck
Word
8h

Donald
Duck
Outlook
3h

Max
Huber
Word
25h

Max
Huber
Excel
15h

Felix
TheCat
Outlook
35h

Felix
TheCat
Word
25h

Felix
TheCat
Excel
15h


SELECT
  first_name,
  last_name,
  MAX(CAST(soft_hours AS UNSIGNED)) AS use_duration
FROM test_tab
GROUP BY first_name, last_name
ORDER BY last_name;


first_name
last_name
use_duration


Donald
Duck
20

Max
Huber
25

Felix
TheCat
35


SELECT 
  t1.first_name, t1.last_name, t1.soft_name, 
  CAST(t1.soft_hours AS UNSIGNED) AS "usage"
FROM test_tab t1
JOIN
(
  SELECT 
    first_name,
    last_name,
    MAX(CAST(soft_hours AS UNSIGNED)) AS use_duration
  FROM test_tab
  GROUP BY first_name, last_name
) AS t2
ON t1.first_name = t2.first_name AND t1.last_name = t2.last_name
AND CAST(t1.soft_hours AS UNSIGNED) = t2.use_duration
ORDER BY t1.last_name;


first_name
last_name
soft_name
usage


Donald
Duck
Excel
20

Max
Huber
Word
25

Felix
TheCat
Outlook
35

first_name	last_name	soft_name	soft_hours
Donald	Duck	Excel	20h
Donald	Duck	Word	8h
Donald	Duck	Outlook	3h
Max	Huber	Word	25h
Max	Huber	Excel	15h
Felix	TheCat	Outlook	35h
Felix	TheCat	Word	25h
Felix	TheCat	Excel	15h