GIPL Interview Question

query optimization for one table