Ask questions like:
SELECT
journey_asset.name,
journey_stageasset.score
FROM journey_asset
LEFT OUTER JOIN journey_stageasset
ON journey_asset.current_stage_asset_id = journey_stageasset.id
WHERE journey_asset.deleted_at IS NULL
AND journey_asset.journey_id = 8
AND NOT journey_asset.is_average
AND journey_asset.is_active
ORDER BY journey_stageasset.score DESC,
journey_asset.id ASC
LIMIT 3;
{'action': 'check-email', 'target': 'columns', 'column': 'B'}
{'action': 'focus', 'target': 'ribbon'}
SELECT
journey_asset.name,
journey_stageasset.score
FROM journey_asset
LEFT OUTER JOIN journey_stageasset
ON journey_asset.current_stage_asset_id = journey_stageasset.id
WHERE journey_asset.deleted_at IS NULL
AND journey_asset.journey_id = 5
AND NOT journey_asset.is_average
AND journey_asset.is_active
ORDER BY journey_stageasset.score DESC,
journey_asset.id ASC
LIMIT 1;
SELECT DISTINCT ON (journey_stage.position)
journey_asset.name AS asset_name,
journey_stage.name AS phase_name,
journey_stage.position + 1 AS phase_number,
journey_stageasset.score
FROM
journey_asset
LEFT OUTER JOIN
journey_stageasset ON journey_asset.current_stage_asset_id = journey_stageasset.id
LEFT OUTER JOIN
journey_stage ON journey_stageasset.stage_id = journey_stage.id
WHERE
journey_asset.deleted_at IS NULL
AND journey_asset.is_active
AND NOT journey_asset.is_average
AND journey_asset.journey_id = 12
ORDER BY
journey_stage.position ASC,
journey_stageasset.score ASC,
journey_asset.id ASC;