I need help here please. *select * from contact fetch first 2 rows only actually fetched the contacts* *but when I did -- select * from contact where subsidiary = 2 fetch first 2 rows only* I got nothing How do I filter by subsidiary?

SELECT 
Contact.fullname AS "contact_full_name",
BUILTIN.DF(ContactSubsidiaryRelationship.subsidiary) AS "contact_subsidiary"
FROM Contact
LEFT JOIN ContactSubsidiaryRelationship ON Contact.id = ContactSubsidiaryRelationship.entity

Something like this...contact doesn't have subsidiary information on the table so it looks like you need the "ContactSubsidiaryRelationship" table as a join.