marriage.sql

sqlite> create table things(user text, girl text, action text, date datetime);
sqlite>  insert into things values ('saml', 'jessica alba', 'married', datetime('now'));
sqlite> insert into things values ('saml', 'jessica alba', 'divorced', datetime('now'));
sqlite>  insert into things values ('saml', 'sigourney weaver', 'married', datetime('now'));
sqlite>  insert into things values ('saml', 'sigourney weaver', 'divorced', datetime('now'));
sqlite>  insert into things values ('saml', 'jessica alba', 'married', datetime('now'));
sqlite> select user,girl,action,max(date) from things where user = 'saml' group by girl;
saml|jessica alba|married|2016-04-06 21:24:09
saml|sigourney weaver|divorced|2016-04-06 21:24:02