Simple interview, 1 SQL question, 1 Case, a few questions on CV. You should know all the concepts you mention in your CV, Also know about joins, subqueries, and CTEs. Interviewer will prompt if you need help.