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.
Junior Intelligence Analyst Interview Questions
5,623 junior intelligence analyst interview questions shared by candidates
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.
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?
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
Viewing 11 - 20 interview questions