SELECT
  percentile_CONT(chatsNumber,
    0.25) OVER()
FROM (
  SELECT
    idJob,
    COUNT(idJob) AS chatsNumber
  FROM
    `merlin_analysis_v2.Chat`
  WHERE
    initiator = idEmployer
    AND timestamp >= TIMESTAMP("2018-02-14")
    AND type = "text"
    AND idJob IN (
    SELECT
      idJob
    FROM
      `merlin_events.Event`
    WHERE
      eventName = "Shortlist"
      AND idJob IN (
      SELECT
        idJob
      FROM
        `datastudioviews.ApprovedJobs`))
  GROUP BY
    idJob)