Hi,
I have a table structure like below.
It illustrates match information based on assets

Users table

I am trying to write a query that shows all assets with a column for the following.
Where s1_match, s2_match or s3_match is populated with the following users, user2, user3,user4. The ordering doesnt matter, the column should only display true or false if all those columns are populated with any of those 3 users.
The query should also for for every asset where any of the following columns has any other user assigned to it apart from user1, user2, user 3, user4. In the example, asset7 and asset11 will be flagged up.
Thanks in advance.