For more current ANSI syntax, you might try rewriting the first query as follows:

SELECT so_title, count(*) as cnt

--Notice the new join syntax below

FROM songs JOIN setlist ON so_soid = sl_soid...

Looking into this was very helpful for me. Coming to SQL Server from other platforms, I had assumed Null + ‘string’ = empty_string + ‘string’ = ‘string’. ...