The topic of JOINs was thoroughly covered (JOINs are old news), but one user (Mani) made this comment: I have gone through videos, but lateral join concept is missing. Please update course with lateral join and use case. This prompted a digression into LATERAL JOINs as it was a new thing to me. My reply… Continue reading LATERAL JOINs in PostgreSQL