Amdocs interview question

Write SQL query to extract some data from a given table?