This was recently during an on-site interview for a data science role. It was fairly basic and involved doing a [code ]LEFT JOIN[/code] on multiple fields.
Lee mas