sql.md

WITH RECURSIVE records AS (
	SELECT shipping_line_id, MIN(total_price)  min_price
	FROM rate_detailed_fcl_freight_charges
	where origin_port_id='58eb6135c0a35f29ced559c0' and destination_port_id='58ef81f3c0a35f0983b17969' and container_type='standard' and container_size='20' and commodity='general'
	GROUP BY shipping_line_id
)
SELECT
	r.shipping_line_id,
	r.min_price,
	frt.freight_forwarder_id,
	MAX(frt.date) DATE
FROM rate_detailed_fcl_freight_charges frt JOIN records r ON 
	frt.shipping_line_id = r.shipping_line_id 
	AND frt.total_price = r.min_price	
GROUP BY r.shipping_line_id, r.min_price, frt.freight_forwarder_id
LIMIT 50;