Write SQL query to solve given problem: List all the name of products with the ID of 30 to 40.. Keep the solution inside sql tag ```sql [SQL-Query] ```
SELECT T FROM ( SELECT CASE  WHEN ProductID BETWEEN 30 AND 40 THEN `Product Name` ELSE NULL END AS T FROM Products ) WHERE T IS NOT NULL