SELECT
    bikeshare_regions.name AS region_name,
    COUNT (bikeshare_trips.trip_id) AS total_trips,
    COUNT (DISTINCT bikeshare_trips.bike_number) AS total_bikes
FROM `bigquery-public-data.san_francisco_bikeshare.bikeshare_trips` AS bikeshare_trips
    INNER JOIN `bigquery-public-data.san_francisco_bikeshare.bikeshare_station_info` AS bikeshare_station_info
    ON bikeshare_trips.start_station_id = bikeshare_station_info.station_id
    INNER JOIN `bigquery-public-data.san_francisco_bikeshare.bikeshare_regions` AS bikeshare_regions
    ON bikeshare_station_info.region_id = bikeshare_regions.region_id
WHERE
    bikeshare_trips.start_date BETWEEN '2014-01-01' AND '2017-01-01'
GROUP BY 1
ORDER BY 1 DESC;