Starts with introduction, where you would be explaining whats needed. As for the technical bit of it they asked SQL question, where you would be given an example table and an output. You should write the query to get that particular output.
Interview questions [1]
Question 1
How to get the following output using SQL commands