Sales Rep Ranked by Revenue for the Quarter-To-Date (QTD)

WITH salesforce_user AS (
  SELECT
    id, email, firstname || ' ' || lastname AS "rep"
  FROM
    public.salesforce_user
  WHERE
    salesforce_user.IsActive
)
SELECT
  us.rep AS "sales_rep",
  us.email,
  sum(op.amount) AS "revenue"
FROM
  public.salesforce_opportunity op
JOIN
  salesforce_user us
  ON op.ownerid = us.id
WHERE
  op.stagename = 'Closed Won'
  AND DATE_TRUNC('quarter', "closedate") = DATE_TRUNC('quarter', current_date)
GROUP BY
  1,
  2
ORDER BY
  revenue DESC