1. Given the sample: id, status 1, active 2, active 3, active 4, pending 5, expired 6, expired 7, expired 8, pending Pull the unique statuses that show up consecutively 3 times, e.g. from the sample, the output would be 'active', 'expired'. 2. Given the sample: employee, in_out, time A, IN, 6:00 B, IN, 7:00 A, OUT, 8:00 C, IN, 9:30 A, IN, 9:00 A, OUT, 10:00 B, OUT, 11:00 C, OUT, 10:00 Determine which employees are in the building at 10:30.
If you take 3 subsequent number (n, n+1, n+2) and know, that n and n+2 are prime numbers, can you proove, that n+1 is always dividable by 6?
try to get a pattern out of string or json. ask you to translate numbers from 1 to 100 to names of numbers ( for example 34 translated to thirty-four). you need to come with a solution within 10 seconds, I am able to get it done within 2 minutes. That's not fast enough.
Write a constant-time Python 3 implementation of LRU cache. Use any Python data structures. The provided unit tests must pass. You have 15 minutes.
2 Sum
The percentage of female customer base
They answered no questions I sent over and sent my own questions back to me. So that was mighty pathetic too.
phone screen for SQL: Give data model - solve various SQL questions Python: list and dict manipulation
1. Imagine a table keeping track of all the rides a driver undertakes in a given day. How do you query that table to find out the time when he did not have any rides. So the table may have a record when he picks up his first ride and then he picks another and then drops both of them. After a while he picks up a few more which again is recorded in the table. So with all that how do you find the data when he does not have any rides
Asked a live coding on python. Need to execute the program online after coding. And 2 SQL queries where I need to write the query.
Viewing 1 - 10 interview questions