Create bar chart for question written in SQL

Get Help
1 
SELECT

(
    SELECT COUNT(id) 
    FROM bookings
    WHERE `status` = 'collect_payment'
    AND booking_date BETWEEN {{start_booking}} AND {{end_booking}}
)
   +
(
    SELECT SUM(main_service_count) 
    FROM offline_bookings
    WHERE `date` BETWEEN {{start_booking}} AND {{end_booking}}
    AND `status` = true 
)

I want to create bar chart for the above question such that it shows me the number monthly on bar chart

the above question is the sum of online bookings and offline bookings

2

Hi @Mohammad_Abdallah
You'll need to return the date as well, grouped. It's probably easier to do with a CTE: https://www.metabase.com/learn/sql-questions/sql-cte