Aceware interview question

Write an SQL query ?