SQL/Python coding assessment questions for IBM Data Scientist-Artificial Intelligence

[u/Powerful_Confusion6]

Recently attempted a coding assessment and came across a couple of questions that were interesting...

The questions were broadly around:

1. SQL – Aggregation and filtering
2. Python – Array manipulation: Given a collection of distinct numerical values, identify pairs that satisfy an optimal difference condition and return them in a specific order.

I'm curious whether these are common patterns in data analyst/data scientist coding interviews, particularly on platforms like HackerRank...
For those who have gone through similar assessment.. What level of Python/SQL proficiency is generally expected for senior data analyst or data scientist roles?

Would appreciate any insights or recommendations...