#FirstSQL

This purpose of the query is to find the first item that was purchased by each customer after their membership join date.
It can also be assumed that you can buy an item on the day you join as a member.