eGain interview question

Write a select statement in SQL.