Write SQL query to solve given problem: How many no.9 items from store no.11 were sold on 2012/12/7?. Keep the solution inside sql tag ```sql [SQL-Query] ```
SELECT units FROM sales_in_weather WHERE `date` = '2012-12-07' AND store_nbr = 11 AND item_nbr = 9