Calculate the average fare amount for each area. Exclude fares with value 0.

avg_fare_amount.sql

SELECT
  pickup_polyId,
  SUM(fare_amount)/COUNT(*) AS average_fare,
  COUNT(*) AS no_of_trips
FROM
  [nyctaximap:dataflow.nyc_output_join_fare_distinct]
WHERE
  fare_amount!=0
GROUP BY
  pickup_polyId
HAVING
  no_of_trips > 100000
ORDER BY
  average_fare DESC;