EY SQL BI Developer interview questions

They asked me join the Teams, then started with: Introduction sql theoritical questions like : joins, store procedures, self join, views and asked to share screen and given some sql problem to write the quries like: delete duplicates in a table, 2 nd highest salary, remove special characters in a string, convert the string to date format add reduce 15 days from that date powerbi: can we use measure in a calculated column