-- Database schema
| Songs : SongId [ INT ] primary_key , Title [ TEXT ] | Albums : AId [ INT ] primary_key , Title [ TEXT ] , Year [ INT ] , Label [ TEXT ] , Type [ TEXT ] | Band : Id [ INT ] primary_key , Firstname [ TEXT ] , Lastname [ TEXT ] | Instruments : SongId [ INT ] primary_key Instruments.SongId = Songs.SongId , BandmateId [ INT ] Instruments.BandmateId = Band.Id , Instrument [ TEXT ] | Performance : SongId [ INT ] primary_key Performance.SongId = Songs.SongId , Bandmate [ INT ] Performance.Bandmate = Band.Id , StagePosition [ TEXT ] | Tracklists : AlbumId [ INT ] primary_key Tracklists.AlbumId = Albums.AId , Position [ INT ] , SongId [ INT ] Tracklists.SongId = Songs.SongId | Vocals : SongId [ INT ] primary_key Vocals.SongId = Songs.SongId , Bandmate [ INT ] Vocals.Bandmate = Band.Id , Type [ TEXT ] |
-- -- What is the last name of the musician who was in the most songs?

SELECT T2.lastname FROM Performance AS T1 JOIN Band AS T2 ON T1.bandmate  =  T2.id JOIN Songs AS T3 ON T3.SongId  =  T1.SongId GROUP BY lastname ORDER BY count(*) DESC LIMIT 1;