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;
 

typeID	typeName	rank
3300	Gunnery	1
3301	Small Hybrid Turret	1
3302	Small Projectile Turret	1
3303	Small Energy Turret	1
3304	Medium Hybrid Turret	3
3305	Medium Projectile Turret	3
3306	Medium Energy Turret	3
3307	Large Hybrid Turret	5
3308	Large Projectile Turret	5
3309	Large Energy Turret	5
3310	Rapid Firing	2
3311	Sharpshooter	2
3312	Motion Prediction	2
3315	Surgical Strike	4
3316	Controlled Bursts	2