Create a pivot-style table: each row should correspond to a month, and separate columns should correspond to payment types. The cells should contain the total revenue for each payment type. Use conditional aggregation and exclude rows without a pickup date, payment type, or cost.
Write your request in the field below and click the "Check it!" button.
Use DuckDB syntax to write your answer. Descriptions of tables are provided at the bottom of the screen.