DECLARE @Company TABLE (CompanyId INT, CompanyName VARCHAR(30))
DECLARE @Job TABLE (JobId INT, CompanyId INT, Name VARCHAR(100))

INSERT INTO @Company
             SELECT 1, 'Acme'
   UNION ALL SELECT 2, 'Umbrella Corp.'

INSERT INTO @Job
             SELECT 1, 1, 'John Doe'
   UNION ALL SELECT 2, 1, 'Jane Doe'
   UNION ALL SELECT 3, 2, 'Alice'

; WITH
JobCount AS
(
   SELECT
         CompanyId,
         COUNT(*) JobCount
      FROM @Job
      GROUP BY CompanyId
),
Cust AS
(
   SELECT
         c.CompanyId,
         j.JobCount,
         ROW_NUMBER() OVER (ORDER BY j.JobCount) AS RowNumber
      FROM @Company c
         JOIN JobCount j ON c.CompanyId = j.CompanyId
)
SELECT 
      * 
   FROM Cust

; WITH JobCount AS (
   SELECT
         CompanyId,
         COUNT(*) JobCount
      FROM @Job
      GROUP BY CompanyId
), Cust AS (
   SELECT
         c.CompanyId,
         j.JobCount,
         ROW_NUMBER() OVER (ORDER BY j.JobCount) AS RowNumber
      FROM @Company c
         JOIN JobCount j ON c.CompanyId = j.CompanyId
)
SELECT
      *
   FROM Cust
-->
 ORDER BY JobCount	--this works
-->