SQL · Waymo · Easy
You are given two tables that store information about rides and the users who took them. Table: rides ride_id is the primary key for this table. Table: users user_id is the primary key for this table. For every calendar month, calculate two figures: the total number of rides that occurred, and the average ride rating. Only ratings that are not null should be included when computing the average. Round the average rating to two decimal places. Return the results ordered by…
Checking your access…