Hacker News new | ask | show | jobs
by phibz 2062 days ago
When I ask SQL questions I'm looking for a few important things.

1. Have you written SQL 2. Do you understand keys and joins 3. Do you understand one to one, one to many, and many to many relationships 4. Do you know any advanced language features: window functions, CTEs, grouping sets, strategies for pivoting data in different dbs, etc.

I don't care if you write syntactically correct SQL or even remember all the keywords. Just as long as you can talk intelligently about some of those concepts.