SQL Coding: 5 questions 4 tables were given and questions were mostly on joins, aggregate functions, sub queries. Python Coding: I guess there were total 5 questions but could reach only till second question. Count the number of words in a sentence. Count the frequency of words from the list and store the results in a hash map.
SQL - Q1. Find the IDs of the top 5 customers, ordered by average payment per book made by the people they invited.
Python (1) Count "char" in the string. (2) Replace "None" in an array. Codes are simple but passing edge cases are difficult. SQL several % calculation questions
Find max min avg of the order by date, customer, product, state. Coding was easy pretty much what people already posted here.
What percent of all products in the grocery chain's catalog are both low fat and recyclable?
Write a query that returns product_family, units_sold, percentage of promoted.
How do you educate yourself?
The rest 30minutes was for algorithmic programming in language of your choice. I completed 3.5 questions in 30minutes.
Basic data structure and sql statement at a very high level short answers
sql and python question 5+5
Viewing 191 - 200 interview questions