This should work, you would just have to adjust the column name
tracks.duration
if it's different:
SELECT a.albumid, a.name, g.name as genrename, sum(t.duration) as albumduration
FROM albums a
JOIN genre g
ON a.genreid=g.genreid
JOIN tracks t
ON a.albumid=t.albumid
GROUP BY a.albumid, a.name, g.name
ORDER BY a.name;