SELECT с использованием объединения нескольких запросов вместе (UNION):
SELECT t.Creation_Date, a.Full_Name, t.Name, t.Questions_Amount
FROM dbo.TestCase t, dbo.Account a
WHERE t.Id_Creator = a.Id AND t.Questions_Amount = 2
UNION
SELECT '2015-12-21 00:00:00.000', 'Some name', 'Some subject', 5
UNION
SELECT t.Creation_Date, a.Full_Name, t.Name, t.Questions_Amount
FROM dbo.TestCase t, dbo.Account a
WHERE t.Id_Creator = a.Id AND t.Questions_Amount = 1
ORDER BY t.Questions_Amount -- order by must be in the select list