List all the name of products with the ID of 30 to 40.
products with the ID of 30 to 40 refer to Product Name WHERE ProductID BETWEEN 30 AND 40;
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