f-4.sql

SELECT
  b.cluster_name,
  SUM(a.total_shipments) AS total_shipments
FROM (
  SELECT
    booking_cluster_id,
    1 AS total_shipments
  FROM shipment
  WHERE 1=1
     AND timestamp BETWEEN '{{ last_sunday }}' 
     AND '{{ this_saturday }}'
  ) shipment
JOIN (
SELECT
  cluster_id,
  cluster_name
FROM locations
WHERE 1=1
  AND timestamp BETWEEN '{{ latest_ds }}'
) b
ON (a.booking_cluster_id = b.cluster_id)
GROUP BY b.cluster_name;