Sopra Steria interview question

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