Opera Solutions Project Analyst II interview questions

first round written technical test it was tough but i cleared it included aptitutude,sql,english test , second round with manager manager would ask questions based on your resume it was easy manger would ask easy question , he asked me to write a sql query to generate multiple records from multiple table