I'm studying for a live test in which I'll be put in front of a computer and given queries to write. This is not for a DBA position, it's a C# developer's role.
What kinds of questions would you pose?
I'd love to see them and see how many I could write without getting stumped. I expect at least a few joins, and imagine at least one where the query is embedded in another querie. (What's that called?)
thnks for the help,