SQL query for installed software per device

[lilith_wild]

I have tried the SQL queries listed in the github, but they no longer verify.