HSBC Intern Data Science/Software Engineer interview questions

Introduce yourself. Why do you want to be a Data Analyst? Why are you interested in ML/AI? Python: Combine two tables using pandas and plot the data. Python: Check if a string is a palindrome. Python: Reverse a substring in a string. Python: Count and display frequency of each character in a string. SQL: What is the RANK() function? SQL: Difference between UNION and UNION ALL. SQL: Difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, OUTER JOIN. (Problems on it ) Behavioral: Describe a scenario where you implemented a process that worked successfully