Imagine that i have a table like below,i want to write a query that give me below result,is it possible?

[![enter image description here](https://i.stack.imgur.com/hJERm.jpg)](https://i.stack.imgur.com/hJERm.jpg)

Result:

```
100 , 2015-01-01 , ABC , XYZ

```