---

SELECT 
    sr.ServiceRequestId,
    sr.RequestTime,
    ru.UserName,
    rt.Type AS RequestTypeName -- Используем столбец Type и даем ему понятный псевдоним
FROM 
    [ServiceRequest] AS sr -- Исправлено на ServiceRequest
JOIN 
    [RequestUser] AS ru ON sr.RequestUserId = ru.RequestUserId -- Исправлено на RequestUser
JOIN 
    [RequestType] AS rt ON sr.RequestTypeId = rt.RequestTypeId
WHERE 
    rt.Type = 'AcquireLicense' -- Исправлено на столбец Type
ORDER BY 
    sr.RequestTime DESC;