ivankovavika

SELECT n.name, count(dropoff_location_id)
FROM `trips` as t
INNER JOIN neighborhoods as n ON n.neighborhood_id = t.dropoff_location_id
WHERE end_ts >= '2016-11-17 00:00:00' AND end_ts <= '2017-11-17 23:59:59'
GROUP BY dropoff_location_id;

SELECT DISTINCT
    company_name 
FROM cabs 
WHERE NOT (company_name LIKE ‘%Chicago%’ OR  company_name  LIKE  ‘%taxi%’ )
LIMIT 10;