Chico's FAS SQL Developer interview questions

I applied on linkedin...got a email from recruiter to schedule the technical interview call with three person. 2 days later I joined the call with manager and senior developer ..They asked me about myself, what you did,what you want to do. Explained about the job role. Asked few question on SQL...DML VS DDL, Clustered index etc. not much. After 2 hours I got a call from recruiter that I have been selected for onsite interview. They called me on their own expense...It was 7 rounds each half n hour. All different members..sales,analyst,developer,manager,store manager,HR, director. technical was bit tough asked too many question on SQL- tables, inner join, outer join,non-clustered index...Lot of questions from resume...rest all the rounds were very good..they are very friendly...I really enjoyed the interview....After two days they called me and said I am selected.