It was an on campus interview with the hiring team members from the local Urban Science coming to interview. They wanted a intern who has a background of Data Analysis and asked basic behavioral questions like about me, why did u choose ur univ, why Urban science etc. Then they came up to asking basic SQL questions like Primary key, joins, gave an example to implement join and write a query.