[Solved] Complex query on sql lite xcode

by


Try this:

SELECT a.artistname,
    (SELECT COUNT(*) FROM track t
    WHERE t.trackartist = a.artistid)
FROM artist a

solved Complex query on sql lite xcode