View All num of num See all Photos BlackRock www.blackrock.com Engaged Employer Overview Reviews Salaries Interviews Jobs Photos Benefits 764 Reviews 1.9k Salaries 517 Interviews Follow Add Review or Salary Follow Add Review or Salary Interview Question Software Engineer Intern Interview San Francisco, CA BlackRock One guy asked a really hard SQL question. I feel that if you have that question and get it right, you will probably get a position. He first asked a sorta easy sql question. The question is that you have a list of portfolios. You also have a list of portGroups (basically a group of protfolios). If firsts asks you to create a table to hold some data for both these values. Make sure you don't create two separate tables with keys! He wants to see that you can create one table and use both the portfolio number AND the portGroup number as the primary key. Next (the hard part), he asked you to pretend that a portGroup is a 'parent' of a portfolio (the child). He asked for me to write some sql joins that would return the parent of the grandparents of a specific portfolio. I honestly still don't understand it. It makes a lot more sense if you right out an example with numbers. You could also try and search online for something similar to this. I guess the key takeaway is to know how to do an innerjoin (and other types of joins) Tags: See more , See less 8 Answer Add Tags Answer Interviews > Software Engineer Intern > BlackRock Add Answers or Comments To comment on this, Sign In or Sign Up.