Hello,
In our data, users' languages are stored in three fields: UI language, preferred language and spoken language.
I am trying to write a question (or SQL query) that calculates all Spanish speakers from UI, Spanish speakers from preferred language and Spanish speakers with no duplicates.
Any tips on how to do this?