Difference between where and having
Intelligence Analyst Manager Interview Questions
6,928 intelligence analyst manager interview questions shared by candidates
1. Tell me about yourself 2. difference between transactional databased and OLAP 3. pick a field you are strong in and then follow up questions were asked SQL: given a table consisting of routes including source and destination find the sources which are never a destination. (something like that, don't remember exactly)
Given and orders table and a products table give me all products that had sales in 2016 and no sales in 2017
Given an orders table and a products table give me a list of all product categories, the number or orders they had and the total revenue.
Look up questions that go around their leadership principles: I don't remember the exact questions, but if you do t
About a project where I used metrics to capture business insights.
SQL - Top 2 highest salaries by department.
Order Table OrderID|Merch ID|MerchantID|Category|date|price|quantity|…… MerchantID|ID|Name|Status 1. To find out all merchants with ‘Amazon’ in name and return a column ‘internal customer’ if Upper(Amazon) in name or else ‘3P Seller’. Return Null if the merchant name is null
4. What is ETL? what it is used for
Tell me about yourself. Why Amazon?
Viewing 751 - 760 interview questions