what's the average time of purchase for white membership card?
SELECT avg ( time_of_purchase )  FROM member WHERE membership_card  =  "White"
average time of purchase refers to AVG(time_of_purchase); for white membership card refers to WHERE membership_card = 'White';