Morgan Stanley Interview Question

Return to work program-Techinical Round. Self Introduction,carrer gap,wht have done during break,explained about the program and then below are the few queries SQL queries-1.given a series and asked me to give rank,dense rank. 2.query-to find out duplicate email id in the table. 3.sql query to find the class which has morethan 3 students 4.find all the dates with higher temp compared to previous dates