Logistimo interview questions

Total 4 rounds of interview. 1 round : Skype interview which involved questions on testing methodologies,testing types, test scenarios writing, process we follow in current company,test managemet tool,bug life cycle...what not everything is asked....n this is completely discussion. 2 round: Face to face with test manager..this is kind of screwing me up with question on SQL basic queries group by,order by ....Testing process bug life cycle and STLC and scenarios, was given one search section and how to write test scenarios...its very lenghty..it took 2.5 hours for discussion and went well. 3 round : HR round with basic questions wht r u expecting from company,where do u want to see urself in the company etc... 4 round: Discussion with the CTO and it lasted for an hour and here some behavioural question... Totally the interview went well but its lengthy,,but one thing to say is "interviewers are very supportive and professional and liked the way they proceeded.. Finally offer released and joined Logistimo.