TEOCO interview question

Basic sql and unix question