SELECT
    CASE q.cert_test_id WHEN 4 THEN 1 ELSE 2 END AS [CertificationID],
    1 AS [ProficiencyID],
    q.id AS [QuestionID],
    q.question AS [Text],
    q.active AS [IsActive],
    q.datetimemodified AS [ModifiedDate],
    CASE q.updatedby WHEN N'Greg Rose' THEN N'greg' WHEN N'Brett Killian' THEN N'brett' ELSE N'koistya' END AS [ModifiedBy]
FROM [OldTPI].[dbo].[cert_test_question] AS q
WHERE q.cert_test_id IN (4, 22)