How do I nest the following two queries?

I am trying to sum Duration from table scrap_log and filter via Reason but I want to use the matching string from table scrap_reasons where it holds the same product code integers.

SELECT Reason, SUM(Duration) FROM scrap_log GROUP by Reason

SELECT scrap_reasons.description, scrap_reasons.code
FROM  scrap_reasons
JOIN scrap_log ON scrap_log.Reason=scrap_reasons.code

I tried many different ways of doing this.

scrap_log

scrap_reasons

OUTPUT

CodePudding user response：

select   sum(scrap_log.Duration) as total
        ,scrap_reasons.description
from     scrap_log join scrap_reasons on scrap_reasons.code = scrap_log.Reason
group by scrap_reasons.description  

Fiddle