MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
-- create tables
create table Table1 (
  Id int not null auto_increment,
  Name varchar(255) not null,
  primary key(Id)
);

create table Table2 (
  Id int not null auto_increment,
  Name varchar(255) not null,
  Table1_Id int not null,
  primary key(Id),
  foreign key(Table1_Id) references Table1(Id)  
);


create table Table3 (
  Id int not null auto_increment,
  Type varchar(255) not null,
  Name varchar(255) not null,
  Result varchar(255) not null,
  Table2_Id int not null,
  primary key(Id),
  foreign key(Table2_Id) references Table2(Id)
);

-- insert data
insert into Table1 (Name) values ('Computer A');

insert into Table2 (Name, Table1_Id) values ('Test Run 1', 1);

insert into Table3 (Type, Name, Result, Table2_Id) values
('Processor', 'MMX', 'Pass', 1),
('Processor', 'SSE', 'Pass', 1),
('Processor', 'SSE 2', 'Pass', 1),
('Display', 'Red', 'Pass', 1),
('Display', 'Green', 'Pass', 1),
('Keyboard', 'General', 'Pass', 1),
('Keyboard', 'Lights', 'Skipped', 1),
('Network', 'Ethernet', 'Pass', 1),
('Network', 'Wireless', 'Skipped', 1),
('Network', 'Bluetooth', 'Fail', 1);
SELECT table1_name,
       GROUP_CONCAT(Type, ': ', SUBSTRING_INDEX(Results, ',', 1) SEPARATOR ', ') test_result
FROM (
  SELECT t1.Name table1_name, t3.Type,
       GROUP_CONCAT(Result ORDER BY Result = 'Fail' DESC, Result = 'Skipped' DESC) Results
  FROM Table1 t1
  INNER JOIN Table2 t2 on t1.Id = t2.Table1_Id
  INNER JOIN Table3 t3 on t2.Id = t3.Table2_Id
  GROUP BY t1.Name, t3.Type
) t
GROUP BY table1_name;


table1_name
test_result


Computer A
Display: Pass, Keyboard: Skipped, Network: Fail, Processor: Pass


SELECT table1_name,
       GROUP_CONCAT(Type, ': ', SUBSTRING_INDEX(Results, ',', 1) ORDER BY Id SEPARATOR ', ') test_result
FROM (
  SELECT t1.Name table1_name, MIN(t3.Id) Id, t3.Type,
         GROUP_CONCAT(Result ORDER BY Result = 'Fail' DESC, Result = 'Skipped' DESC) Results
  FROM Table1 t1
  INNER JOIN Table2 t2 on t1.Id = t2.Table1_Id
  INNER JOIN Table3 t3 on t2.Id = t3.Table2_Id
  GROUP BY t1.Name, t3.Type
) t
GROUP BY table1_name;


table1_name
test_result


Computer A
Processor: Pass, Display: Pass, Keyboard: Skipped, Network: Fail