Please share sample codes in text format. You can achieve the result by below query

with Artist as (
select recording_artist_id,artist_name, 

(select count(*) from album,song,musical_genre mg
where album.album_id=song.album_id and mg.musical_genre_id=album.musicalgenre_id...

A size where I can find the delay. And if BudgetAccount and MainAccount have 100 rows then display table should be based on those rows. I am really want to...

at both BudgetAccount and MainAccount there are 100 rows. BudgetAccount consists 5 unique accountID and MainAccount consists of only one where as there is 104 unique AccountID in display table....

Can you provide some data for first two temp tables?