Assistant System Engineer

We get 30 mins to solve 1 questions for the ASE role .

Interviewer was very friendly to me, Interview started by introducing each other.
I mentioned my past internship in my introduction. As a result, he began asking me questions regarding my internship, such as how I contributed to the project and whether I had any creative ideas for the project. I responded to each and every one of them.
Then he began asking questions about my college projects, which were built using flutter and firebase, such as what the architecture of the project was and how you handled request and response immediately after launching the app. He questioned about my contribution to the project because it was a group activity. I described to him how I developed role-based authentication in my project.
After we talked about the project and past internship, he asked if I was familiar with SQL. Yes, I said. After that, he asked me to write two queries. The first was to identify the employee with the highest salary from the employee table, which had the attributes employee name and salary. I wrote a query using MAX() function .He then proceeded on to the second question, which was to identify the second highest salary from the table, I have written SELECT salary FROM employee ORDER BY salary desc limit (1,1). Then he told me that when we have a table with thousands of rows, this query will take a long time, and he asked me to improve it. He also gave me a hint to use corelated queries, and I was able to write an optimized query after that using nested query.