QUERYX allows you to use sql queries in sheets.

Those familiar with Google Sheets will probably want to know how this is different to the built-in QUERY() function, the answer is this is add-on enables a full SQL. Following the source link gives information on how to access this add-on.

Source: [PROMO] QUERYX allows you to use sql queries in sheets. – Google Groups