data

Custom SQL query returning 1 row (hide)

with today_points as ( select datetime, mllw_feet from tide_predictions where date("datetime") = :p0 and "station_id" = :p1 ), min_max as (select min(mllw_feet) as min_feet, max(mllw_feet) as max_feet from today_points), points as (select RANK () OVER ( ORDER BY datetime ) -1 as rank, min_max.min_feet, min_max.max_feet, mllw_feet, (100 * (mllw_feet - min_max.min_feet) / (min_max.max_feet - min_max.min_feet)) as line_height_pct from tide_predictions, min_max where date("datetime") = :p0 and "station_id" = :p1 order by datetime) select group_concat(rank || ',' || line_height_pct, ' ') from points

Query parameters

p1

p0