SELECT LEFT(DATE(pickup_datetime),7) as month,
SUM(fare_amount) as total_revenue,
COUNT(*) as num_fares
FROM [nyc-tlc:yellow.trips_2014], [nyc-tlc:yellow.trips_2015]
GROUP BY month ORDER BY month
Here's the quick-and-dirty output: https://docs.google.com/spreadsheets/d/1NVcScdHtcWvF9oSZGE3_...If Uber is eating the TLC's lunch, why isn't there a dramatic shift in revenue loss? (trendline has only a slight decline) However, it does appear the # fares are on a downward trend.