AT&T interview question

Queries to write by giving a scenario in SQL,Unix basic shell scripting