How many users are there?
select count(*) from user_profiles
Please list their names and email.
select name, email from user_profiles
How many followers do they have?
select name, email, followers from user_profiles
How many users' emails contain ‘superstar’ or ‘edu’?
select count(*) from user_profiles where email like '%superstar%' or email like '%edu%'
Please list their names.
select name from user_profiles where email like '%superstar%' or email like '%edu%'