gistfile1.txt

mysql> show tables;
+--------------------------+
| Tables_in_staging        |
+--------------------------+
| demo                     |
| projects                 |
| report_test_coverage     |
| test_automation_coverage |
| test_automation_status   |
| test_sub_suites          |
| test_suites              |
+--------------------------+
7 rows in set (0.15 sec)

mysql> 
SELECT  
   proj.project_name_abbrev,  
   proj.project_name,  
   tss.test_sub_suite_abbrev, 
   tas.status, tac.coverage, 
   report.percentage  
FROM report_test_coverage AS report 
LEFT JOIN projects AS proj ON proj.id = report.projects_id 
LEFT JOIN test_sub_suites AS tss ON tss.id = report.test_sub_suites_id 
LEFT JOIN test_automation_status AS tas ON tas.id = report.test_automation_status_id 
LEFT JOIN test_automation_coverage AS tac ON tac.id = report.test_automation_coverage_id;

+---------------------+---------------+-----------------------+------------+----------+------------+
| project_name_abbrev | project_name  | test_sub_suite_abbrev | status     | coverage | percentage |
+---------------------+---------------+-----------------------+------------+----------+------------+
| fenix               | Fenix Browser | functional            | Untriaged  | None     |         25 |
| fenix               | Fenix Browser | functional            | Untriaged  | None     |         17 |
| fenix               | Fenix Browser | functional            | Unsuitable | None     |         55 |
| fenix               | Fenix Browser | functional            | Completed  | Partial  |         31 |
| fenix               | Fenix Browser | functional            | Disabled   | Full     |         64 |
+---------------------+---------------+-----------------------+------------+----------+------------+
5 rows in set (0.16 sec)

mysql>