Good day everyone,

I have a Microsoft contract interview coming up and I know they will be asking me whiteboard ad-hoc SQL query questions. I tend to kind of freeze up in these situations. I was wondering if anyone has strategies/processes they use to divide and conquer complex select query statements? I think that if I had more of a structured process in my mind it would be a whole lot easier to keep things straight. I already have the basics such as understanding of row and group filtering, joins, et al.

Thanks,
Sean

Got any example questions?

Do you have SQL development experience?

pootle flump ur codings are working excelent.

Maybe the following sql exercise site will help you a little...
SQL exercises