Dynamics CRM is a widely used cloud CRM from Microsoft, focused on Sales, Marketing, and Service (help desk) sectors.
SELECT
o."name" 'Topic', o."estimatedvalue" 'Est. Revenue'
FROM
"opportunity" o
INNER JOIN
"owner" AS owner_o ON o."ownerid" = owner_o."ownerid"
WHERE
o."statecode"='Open' AND owner_o."name" = 'Devart Corp'
ORDER BY
o."estimatedvalue" desc
LIMIT 10
