/* 08. Non-Directory Files */

SELECT p.Id,
	   p.[Name],
	   CAST(p.Size AS VARCHAR) + 'KB' AS Size
FROM Files AS p
LEFT JOIN Files AS f ON f.ParentId = p.Id
WHERE f.Id IS NULL
ORDER BY p.Id, p.[Name], P.Size