SELECT * FROM(SELECT airbnbdata.*,
       zmrp.price AS zillow_monthly_price, zmrp.city, CAST((zmrp.price/airbnbdata.median_per_day) as numeric(10,2)) as revenue_crossover_point
FROM   (SELECT a.zipcode,
               a.DATE,
               a.bedrooms,
               PERCENTILE_CONT(0.5)
                 within GROUP ( ORDER BY a.price ) AS median_per_day
        FROM   (SELECT filted_listing.neighbourhood_cleansed AS zipcode,
                       Date_trunc('month', calendar.DATE)    AS DATE,
                       filted_listing.bedrooms,
                       CASE
                         WHEN calendar.price IS NULL THEN filted_listing.price
                         ELSE calendar.price
                       END
                FROM   (SELECT *
                        FROM   listing
                        WHERE  room_type = 'Entire home/apt'
                               AND bedrooms > 0
                               AND bedrooms IS NOT NULL
                               AND last_scraped IS NOT NULL
                               AND neighbourhood_cleansed IS NOT NULL) AS
                       filted_listing,
                       calendar
                WHERE  filted_listing.id = calendar.listing_id) AS a
        GROUP  BY zipcode,
                  DATE,
                  bedrooms) AS airbnbData,
       zillow_median_rental_price AS zmrp
WHERE  airbnbData.zipcode = zmrp.zipcode
       AND airbnbData.DATE = zmrp.DATE
       AND airbnbData.bedrooms = zmrp.bedrooms) as final_table
WHERE upper(city) = 'BOSTON'