Could you show me the IDs for the investors who have the top 3 number of transactions?
select t2.investor_id from investors as t1 join transactions as t2 on t1.investor_id = t2.investor_id group by t2.investor_id order by count ( * ) desc limit 3
Could you add in the investor details to the table please?
select t2.investor_id, t1.investor_details from investors as t1 join transactions as t2 on t1.investor_id = t2.investor_id group by t2.investor_id order by count ( * ) desc limit 3
Could you show me the IDs for the investors who have the bottom 3 number of transactions?
select t2.investor_id from investors as t1 join transactions as t2 on t1.investor_id = t2.investor_id group by t2.investor_id order by count ( * ) asc limit 3
What are the investor ID and details for the investor who had the earliest transaction date?
select t2.investor_id, t1.investor_details from investors as t1 join transactions as t2 on t1.investor_id = t2.investor_id group by t2.investor_id order by t2.date_of_transaction asc limit 1