instruction: how many patients on miconazole powder 2% prescription have been hospitalized for more than 29 days?
response: SELECT COUNT(DISTINCT demographic.subject_id) FROM demographic INNER JOIN prescriptions ON demographic.hadm_id = prescriptions.hadm_id WHERE demographic.days_stay > "29" AND prescriptions.drug = "Miconazole Powder 2%"