Quinte Financial Technologies Data Analyst Interview Questions and Answers for Experienced

2 SQL Leet code challenge questions and 1 Python program.

Q1. Basics of SQL, Python and Tableau
Add your answer
Q2. How to select consecutive data from a column
Ans. 
Use SQL query with window functions like ROW_NUMBER() to select consecutive data from a column
• Use ROW_NUMBER() to assign a unique number to each row based on a specific order

• Use a self join or subquery to compare the row numbers of consecutive rows

• Filter the rows where the row numbers are consecutive to select the consecutive data
Answered by AI
Add your answer
Q3. Write a select query to find highest unique number in a column
Ans. 
Use a subquery to find the highest number that appears only once in a column
• Use a subquery to filter out numbers that appear more than once

• Order the results in descending order and select the top 1
Answered by AI
Add your answer

Q1. About previous experiences
Add your answer
Q2. About previous projects
Add your answer