There were 2 person interviewing me. They introduces themselves then I followed. I had personal questions such as why I choose this sector, why data etc. (also a career shift regarding my CV). Technical questions were mostly based on SQL and some in python and general coding structures.
I was asked to share my screen and print some elements from a table using SQL. Also something using "SUM" operator and some others.
Note: If you memorize every SQL syntax, you'll succeed the interview. They look for people who have good memorization rather than the ones with problem solving or thinking ability