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.