How to write Sql query to view contacts in a viber group?

Question

SQLite

Good afternoon, help with a sql query so that you can pull out phone numbers from the Viber group)
Maybe someone knows the correct query, just the one below does not fully give information (
only for 3 contacts
SELECT * FROM "Contact" WHERE "ContactID" IN (SELECT " ContactID" FROM "ChatRelation" WHERE "ChatID" = (SELECT "ChatID" FROM "ChatInfo" WHERE "Name" = "GROUP NAME") );