SQL questioned asked in interview
Business Intelligence Engineer Interview Questions
1,082 business intelligence engineer interview questions shared by candidates
SQL, Python, Star vs Snowflake, ETL, C++, Hive and Map Reduce, precious projects experinece, challenges
If you were stuck on a desert island with a database that contained all the knowledge ever created, but you only had 10 SQL statements that you could ever use, what would they be?
Q3 How many units were sold in each category that cost less than $20, between $20 and $50, and more than $50? Output: category | units_0_20 | units_20_50 | units_50_plus
Q2 What items were ordered yesterday but not ordered today? Output: item_id
SQL query and a Python program with data provided.
4. Find the second highest earner
5. Find customers with 3+ orders in 2014
Get the highest salary in each department
3. Find customers who haven’t placed any orders
Viewing 181 - 190 interview questions