Nice SQL question, Nirmal.

You might want to add examples of users to your bit.io DB where users have only sent messages but not received any messages, then some people who play with bit.io might understand why you are using left join instead of full outer join. Just a thougth!