Coupons.com interview questions

how to do partitioned ranking in sql

First round was on Hacker rank (Cleared) -1 hr Second Technical (Spring Framework, Basic sql queries, Java, About current project, QA Process) - 25 Mins Third round (TestNG, approach of automation, Framework, Selenium,Java,sql,puzzels) - 40 Mins Fourth Round(All about current organization, project, Process, Expected Salary) - 20 Mins Fifth round (Telephoic discussion, Sr. SDET round again a technical round, problem solving, Java, SQL, Agile, Selenium, API testing) - 1 hr Sixth Round the Director round (Telephonic Discussion, More about TestNG, Approch, About Company, Process, Java, API Testing)- 45 Mins