Sopra Steria Interview Question

2nd highest salary in sql? difference in view and materialised view