Practice for the H1 interview with these recently asked interview questions.
| Question | Topic | Difficulty | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL | Medium | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
You have a table containing information about the time that employees have worked on a project. Write a query to find how many unique calendar days each employee worked. Order your query by the Example: An employee worked on two projects, and recorded their time like this:
The number of unique calendar days is therefore 7. SchemaInput:
Output:
ExampleInput:
Output:
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Data Structures & Algorithms | Easy | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
Data Structures & Algorithms | Medium | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
SQL | Easy | |
Machine Learning | Medium | |
Statistics | Medium | |
SQL | Hard | |
Machine Learning | Medium | |
Python | Easy | |
Deep Learning | Hard | |
SQL | Medium | |
Statistics | Easy | |
Machine Learning | Hard |
Check your skills...
How prepared are you for working at H1?
Discussion & Interview Experiences