As memebers of the analytics team, we responsible for supporting all of Yammers other teams including Product dev & Eng, marketing, sales, Customer engagement and Exec team. Pick one of these teams and explain the problems it has and some ways you might go about solving them using data.
(ordr_date, cust_id, product_id, prc_per_unit, unit) ('2020-10-01', '1', 'AA', 10.5, 2), ('2020-11-01', '1', 'BB', 1.5, 3), ('2020-01-01', '1', 'CC', 3.5, 8), ('2020-01-01', '2', 'CC', 4.5, 3), ('2020-01-01', '2', 'BB', 1.5, 3); 1. List the top 20 customers who have the highest spending 2. Find the highest spent product for each customer
From SQL: 1. If there are 2 tables with m and n rows respectively, then what will be the minimum and maximum number of rows in all the joins. 2. Get the 3rd highest employee salary from employee salary table. 3. Given a product table, the new record gets appended in table with the new timestamp for the product ID. Find out the latest row for that particular product with or without analytical functions. 4. Given there are 2 tables of employee details and employee project details, which all employee are not yet assigned a project. For python: 1. Given a product data frame, the new record gets appended in table with the new timestamp for the product ID. Find out the latest data frame for that particular product with pandas.
You have been asked to send an e-mail campaign to customers that have made a purchase on Amazon.com in the past but not recently. Tell me how you would go about the process. Now tell me the structure of the query you would use.
Some sql questions. Tell me a time when you did something without getting your manager's approval. What will you do differently?
employee(employee_id,manager_id,join_date) find all the employees who joined before their manager
Monthly Revenue : company_name,month,revenue Write a query to pull the monthly revenue as columns instead of rows.
Ranking a table by revenue (Add a Rank Column), without using Rank()
Tell me about a time when you persuade others
If a baseball and a bat cost $1.10 together, and the bat costs $1.00 more than the ball, how much does the ball cost?
Viewing 11 - 20 interview questions