Prometheus Group interview question

Write a select statement given this data set