PwC AI Engineer interview questions

In the first technical interview, I was asked some basic AI- and RAG-related questions. The main use case was to design the architecture of a RAG system on an online whiteboard, which I found straightforward. The follow-up questions were also relatively easy. In the second technical interview, I was given a well-known SQL problem often referred to as the "highest salary per department" question. The task was to write an SQL query that returns the employee with the highest salary in each department. Solving it required using JOINs and nested queries.