Which time-series join? ASOF, WINDOW, HORIZON, LT or SPLICE

A plain-language guide to QuestDB's five time-series joins: ASOF, WINDOW, HORIZON, LT and SPLICE, each with a query that runs on the live demo.