Swiss Re interview question

Perform some SQL query between two views. Pretty simple.