SQL:All skills with rank

From EVEDev

 
SELECT DISTINCT
    invTypes.typeID,
    invTypes.typeName,
    dgmTypeAttributes.valueFloat AS rank
FROM
    invTypes
    INNER JOIN invGroups ON (invTypes.groupID = invGroups.groupID)
    INNER JOIN dgmTypeAttributes ON (invTypes.typeID = dgmTypeAttributes.typeID)
WHERE 
    invGroups.categoryID = 16
    AND invTypes.published = 1
    AND dgmTypeAttributes.attributeID = 275
    AND dgmTypeAttributes.valueFloat IS NOT NULL
ORDER BY
    invTypes.typeID;