i have these two tables from a chat application.
<code>CREATETABLE Users( uid int PRIMARYKEY, name text, phone text);CREATETABLE Messages( recipient int REFERENCES Users(uid), sender int REFERENCES Users(uid), time timestamp NOTNULL, message text NOTNULL,PRIMARYKEY(recipient, sender, time));
<code>I want to find which user has more messages as a recipint than a sender. How can i compare these two? i know how to find each one seperately, but then i don't know.