SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE People (
  `Street` VARCHAR(5),
  `Pet` VARCHAR(3),
  `Food` VARCHAR(12),
  `Time` TEXT
);
INSERT INTO People (`Street`, `Pet`, `Food`, `Time`) VALUES
  ('maple', 'dog', 'pizza', '2021/07/28 12:55:56 PM MDT'),
  ('maple', 'cat', 'pizza', '2021/07/28 3:34:56 PM MDT'),
  ('maple', 'dog', 'french fries', '2021/07/28 12:34:56 PM MDT'),
  ('abney', 'dog', 'pizza', '2021/07/28 5:34:56 PM MDT'),
  ('abney', 'cat', 'pizza', '2021/07/28 12:45:56 PM MDT'),
  ('abney', 'dog', 'french fries', '2021/07/28 2:34:56 PM MDT');
SELECT p1.street, p1.pet, p1.food, p2.food
FROM People p1 INNER JOIN People p2
ON p2.street = p1.street AND p2.pet = p1.pet AND p2.time > p1.time
ORDER BY p1.time;


Street
Pet
Food
Food


maple
dog
french fries
pizza

abney
dog
french fries
pizza