sk22 · July 6, 2020 16:50
diff --git a/whatsapp-messages-per-day.sql b/whatsapp-messages-per-day.sql
 select date(timestamp / 1000, 'unixepoch') as date, count(*) as count from messages
 where key_remote_jid = '[email protected]' /* replace with someone's phone number */
 group by date;
diff --git a/whatsapp-most-messages.sql b/whatsapp-most-messages.sql
 /* find the chat partner you have the most messages with */

 select count(*), key_remote_jid from messages
 where key_remote_jid like '%@s.whatsapp.net'
 group by key_remote_jid
 order by count(*) desc;
	select date(timestamp / 1000, 'unixepoch') as date, count(*) as count from messages
	where key_remote_jid = '[email protected]' /* replace with someone's phone number */
	group by date;
	/* find the chat partner you have the most messages with */

	select count(*), key_remote_jid from messages
	where key_remote_jid like '%@s.whatsapp.net'
	group by key_remote_jid
	order by count(*) desc;