Marketing Channel Attribution

You are given the following tables:

attribution table:

user_sessions table:

Identify the first touch attribution for all high value customers (based on CLV > 100). In other words, what marketing channel did these customers first encounter the product. Your output should have the following columns: user_id, marketing_channel