[Solved] Complex query on sql lite xcode

by

[ad_1]

Try this:

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

[ad_2]

solved Complex query on sql lite xcode