Customer Query - SQL (Magento 2)

Question

I want to build a sql query for customer. Information needed:

• customer-email
• customer-type (individual user, company admin,
  company user)

Can you help me to build such a query?

BR

• dotancohen: Which Magento version?
• MagePal Extensions: Take a look at customer_entity table

Answer 1

SELECT email, customer_type

FROM customer_entity

WHERE email = '[email protected]'

AND (customer_type = 'individual' OR customer_type = 'company_admin' OR customer_type = 'company_user');