What is the name of uid 1 ?
select name from user_profiles where uid = 1
How many followers does Mary have ?
select followers from user_profiles where name = 'Mary'
Find the name and partition id for users who tweeted less than twice ?
select t1.partitionid, t1.name from user_profiles as t1 join tweets as t2 where t1.uid = t2.uid group by t2.uid having count ( * ) <2