# Data Analyst Suggestions: Give the applicant a small standalone application with a SQLlight database and ask him to: - Install an IDE, and run the app (technical skill needed) - Correct models so the app display expected results (mapping skills) - Write optimized queries The database could be about Rates and Shipments, and queries could be: - Display the list of shipments for case C212 - Find the list of shipments before 2020 and update the status to be "terminated" - Display the number of containers for each shipment - Calculate rate of T&T data completeness for each Forwarder Bonus: - Find the list of routes to go from A to B with 1 or 2 legs **Database structure** ``` SHIPMENT * Id * CaseNumber * ForwarderId * Rate * status ``` ``` FORWARDER * Id * Name ``` ``` TRACKTRACE * Id * EstimateDepartureTime * EstimateArrivalTime * ActualDepartureTime * ActualArrivalTime ``` ``` RATE: * Id * Origin * Destination * 20FtContainerPrice * 30FtContainerPrice ``` ``` SHIPPEDITEMS: * Id * ItemId * ShipmentId * Quantities ``` ``` ITEM: * Id * Name * QuantityPer20FtContainer: 2 * QuantityPer30FtContainer: 3 ```