Lloyds Banking Group interview questions

For technical round 1. Given a sample SQL dataset, how would you split this and why? 2. A straightforward SQL query question. 3. How to find an outlier in the given dataset For the competency-based part 1. Explain a situation where you made a mistake and how did you fix/overcome it? 2. Explain a situation where you had a non-technical audience. 3. What are your career goals? 4. If you are not able to find a solution to a problem, what would you do next? 5. If you are given a project with 6 months as deadline, how would you approach the project? There were some questions based on my previous experience like, 1. How did you mentor your juniors (explain the process) 2. Explain a typical day at your previous employment.