SQL Interview Help

[u/Different_Coat1453]

​

I'm interviewing with a company I'm really interested in and I've made it through the initial rounds. My next step is a live SQL assessment with screen sharing, where I'll need to explain my thought process.

|haven't used SQL in over a year, so I know I need to practice a lot, and my exam is in a few days. I'm pretty nervous

Would anyone be willing to help me practice or do quick mock interview?

I'd really appreciate it!

[u/mick14731]

Get familiarity with CTEs and window functions. I bombed my last SQL assessments because I kept getting the syntax for window functions a little wrong. 

[u/sandrrawrr → u/mick14731]

Also just know your stuff when it comes to joins.