Infogix interview question

Basic SQL and Unix