Get pageviews under selected path
SELECT
  splitByString('www.tinybird.co', url)[2]
FROM commercial_events
WHERE timestamp >= now() - INTERVAL 1 week
AND url like '%www.tinybird.co%'