Performing set operations UNION, INTERSECT, MINUS with Looker BI tool

The problem:
I would like to list and count all the users who have used product A but never used product B (in a specific period/area/country).

You cannot achieve the desired result by simply slicing this table. One needs a more advanced technique:

- MINUS operation on top of two sets of users:
- Writing a subquery with IN or EXISTS
- Self-joining a fact table

But can I do this with BI tool?

https://kzzzr.github.io/Performing-set-operations-UNION,-INTERSECT,-MINUS-with-Looker-BI-tool/