HR Path interview question

Basic SQL questions, and knowledge about API