Oracle Interview Question

Data related questions, given 3 tables, extract features