my $sql = <<ESQL;
SELECT *,
       (name = 'Greg') + (age = 32) + (state = 'TX') AS score     
    FROM datable
    WHERE score > 0
    ORDER BY score DESC
ESQL