Write SQL query to solve given problem: Among the products under the type "promo brushed steel", how many of them are manufactured by Manufacturer#5?. Keep the solution inside sql tag ```sql [SQL-Query] ```
SELECT COUNT(p_partkey) FROM part WHERE p_type = 'PROMO BRUSHED STEEL' AND p_mfgr = 'Manufacturer#5'