Prometheus Group Interview Question

Write a select statement given this data set