Geotab Interview Experience

Company: GEOTAB

Python :
1. Is python a language that follows pass by value, or pass by reference or pass by object reference
2. What are lambda functions and how to use them
3. Difference between mutable and immutable objects with example.
4. What are Python decorators? Why do we use them

SQL :
1. What is the difference between Inner join and left inner join ?
2. What are window functions ?
3. What is the use of groupby ?

SQL Round
3 tables given as below:

TRIPS
trip_id
vehicle_id
start_time
stop_time

VEHICLE_MAKE
vehicle_id
make_id

MAKES
make_id
make_name

There is a table which contains vehicle trips. Trips are not necessarily in order.

There is a table which contains vehicle makes. Makes are not necessarily known.

PROBLEM: Write SQL code that provides the number of trips that started on September 1st, 2020 for each vehicle with a KNOWN make. 
Order the results by the trip count.

op
 vehicle_id | trip_count 
     4 |     2
     1 |     1
     2 |     1

Date: 20/05/21
For Linkedin Post Please Click Here