Schemas - Sales (sales_id, date , customer_id, Product_id, purchase_amount): Product (P_id, P_Name, Brand_id,B_name) Top 10 products in year XXXX Top 10 products in each year List of customers whose total purchase increased from XXXX-XXXX but decreased from XXXX-XXXX. List of customers who bought both brands "X" & "Y" and at-least 2 products in each brand.
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
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?
The questions are straight forward. The questions asked of me fell into two categories: subject matter expertise, foreign contacts, and criminal history.
Offering 20% discount increases sales by 25% - what's the impact on financials, operations, marketing
Given the fact that revenue will not increase or even decrease a little bit, but with a higher percentage of email registration, will you say this is acceptable?
Let's say Amazon undercuts the price of a similar barstool by 10%. Should we undercut as well, and if we undercut and don't see any improvement in selling performance, what may be the cause for this?
You have a table called Order with Cust_ID, Order_Date, Order_ID, Tran_Amt. Select the top 100 customers with high spend over a year long period.
If you sum the numbers between 1 and 500, what would the total be?
Viewing 1 - 10 interview questions