macOS Find Unread Messages by Sender

# sqlite3 ~/Library/Messages/chat.db

select SUBSTR(fallback_hash, 1, INSTR(fallback_hash, '|') - 1) AS sender, count(*) as c from message where is_read=0 group by sender order by c;

select count(*) from message where is_read=0;