Business Manager Interview Questions

17,701 business manager interview questions shared by candidates

Was asked to write queries for two problems - Q. Table: Customer_orders customer_id order_id order_day  123        27424624    25Dec2011  123        89690900    25Dec2010  797        12131323    25Dec2010  876        67145419    15Dec2011  Write SQL for customers who placed orders on both the days, 25th Dec 2010 and 25th Dec 2011? Customer_id order_id     order_datetime  1234         4141-4814     25/12/2010:06:15:00  1234         4141-4815     25/12/2010:06:20:00  1234         4141-4816     25/12/2010:06:41:00  1234         4141-4817     25/12/2010:06:50:00  8153         2525-1414     26/12/2010:07:13:00  8153         2525-1415     26/12/2010:13:10:10  Let's say I can combine two orders that are placed by the same customer within 20 mins of each other, what % of orders can be combined.
avatar

Business Intelligence Manager

Interviewed at Amazon

3.5
Sep 6, 2018

Was asked to write queries for two problems - Q. Table: Customer_orders customer_id order_id order_day  123        27424624    25Dec2011  123        89690900    25Dec2010  797        12131323    25Dec2010  876        67145419    15Dec2011  Write SQL for customers who placed orders on both the days, 25th Dec 2010 and 25th Dec 2011? Customer_id order_id     order_datetime  1234         4141-4814     25/12/2010:06:15:00  1234         4141-4815     25/12/2010:06:20:00  1234         4141-4816     25/12/2010:06:41:00  1234         4141-4817     25/12/2010:06:50:00  8153         2525-1414     26/12/2010:07:13:00  8153         2525-1415     26/12/2010:13:10:10  Let's say I can combine two orders that are placed by the same customer within 20 mins of each other, what % of orders can be combined.

Viewing 11 - 20 interview questions

Glassdoor has 17,701 interview questions and reports from Business manager interviews. Prepare for your interview. Get hired. Love your job.