entropy.sql

SELECT 
    image_id, 
    image, 
    detection, 
    entropy(detection.scores) as entropy 
FROM (
    SELECT 
        image_id, 
        image,
        explode(ML_PREDICT(class_scores, image)) AS detection 
    FROM coco
) ORDER BY entropy DESC