SELECT COUNT(*) …
counts the number of rows in the analytics.rides table.SELECT * FROM …
retrieves up to 10 rows of data from the analytics.rides table.SELECT vendor_id …
is list of the top 10 vendors, displaying the number of rides and total revenue for each, ordered by the greatest number of rides first.