Rainwave SQL / All albums with number of songs and total song length

rw_all_albums.sql

select
    rw_albums.sid,
    album_name,
    count(song_id) as num_songs,
    sum(song_secondslong) as total_song_length
from
    rw_albums
        join
    rw_songs using (album_id)
where
    rw_albums.sid < 5 and
    song_verified is true
group by
    rw_albums.sid,
    album_name
order by
    album_name,
    rw_albums.sid;