Dynamic text saying "Best low tides in daylight in next 30 days are..." about rockybeaches HOT 5 CLOSED

with lowest_tide_per_day as (
  select
    station_id,
    date(datetime) as date,
    time(datetime) as lowest_tide_time,
    min(mllw_feet) as lowest_tide
  from
    tide_predictions
  where
    station_id = 9414131
  group by
    date(datetime)
)
select
  lowest_tide_per_day.*,
  sunrise_sunset.*
from
  lowest_tide_per_day
  join sunrise_sunset on sunrise_sunset.place = 'pillar-point'
  and sunrise_sunset.day = lowest_tide_per_day.date
where
  lowest_tide_per_day.lowest_tide_time > sunrise_sunset.sunrise
  and lowest_tide_per_day.lowest_tide_time < sunrise_sunset.sunset
  and date >= date('now')
order by
  date