title: How to assign the most recent paid campaign to subsequent visits in SQl?
body: <p>I have a table below with the first five columns. I need to build the sixth column. I'm not sure how to go about this. I need to assign the most recent Paid Campaign a customer came through to subsequent visits. </p>
  
  <p><a href="https://i.stack.imgur.com/H46sg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/H46sg.png" alt="enter image description here"></a></p>