Q1) Find the number of unique days each employee worked Emp Id Task Id Start date End date 1 1 Monday Wednesday 1 2 Monday Tuesday 1 3 Friday Friday 2 1 Monday Friday 2 1 Tuesday Wednesday Hint: Calendar day table or date dimension table Calendar_day Calendar_day_of_week Calendar_year Calendar_month 1900/01/01 Wednesday (3) 1990 1 Q2) How many customers placed orders every month? Table 1: Customer Date customer_id order_id units country 2019/07/01 A 112 5 US 2019/07/02 A 211 4 US 2019/08/02 B 511 4 EU 2019/09/01 C 322 1 JP 2019/09/01 C 322 2 JP 2019/08/05 A 378 6 US 2019/09/10 A 456 7 US
Engineer Interview Questions
934,754 engineer interview questions shared by candidates
Using only putchar how would you print out the ascii values for each digit in an integer. For example if the integer was 123, then you would want to print the ascii values for 1, 2, and 3.
Given an infinite stream of numbers, find the top 50 integers. What's the data structure to use, and what's the time complexity.
Write a program to find the square root of a double.
Write a function to search for a string within another string. Analyze it's complexity, and propose optimizations.
A key is broken on your laptop keyboard. How do you work around it until you can get a new keyboard?
You have words separated by white spaces. You need to reverse their order in place.
If I need to make a cantilever beam 1mm thick and I only have 0.5mm sheet stock. How can I make a beam that has the same properties as the 1mm.
Use objective-c write code to return the first repeated integer from a given array, with O(n) time
write atoi()
Viewing 1081 - 1090 interview questions