What are the lot details associated with these lot ids?
select t1.lot_id, t1.lot_details from lots as t1 join transactions_lots as t2 on t1.lot_id = t2.transaction_id join transactions as t3 on t2.transaction_id = t3.transaction_id where t3.share_count < 50
How many lots have share count smaller than 50?
select count ( t1.lot_id ) from lots as t1 join transactions_lots as t2 on t1.lot_id = t2.transaction_id join transactions as t3 on t2.transaction_id = t3.transaction_id where t3.share_count < 50