Report question

Question: A Select Statement that would do the following