-- 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 ] |
-- -- Hom many musicians performed in the song "Flash"?

SELECT count(*) FROM performance AS T1 JOIN band AS T2 ON T1.bandmate  =  T2.id JOIN songs AS T3 ON T3.songid  =  T1.songid WHERE T3.Title  =  "Flash";