It was an online interview for a campus internship opportunity for the Data Warehousing Role and basic sql queries were asked during the interview such as to retrieve the second highest salary and how to use cross joins