Carpool ride metrics in SQL

For a ride-sharing product that lets riders share a car, write SQL over ride and request tables for a series of metrics, such as completed shared rides per day and averages per ride. Define each metric clearly before writing its query.