Write SQL query to solve given problem: How many products sold by Adam Hernandez?. Keep the solution inside sql tag ```sql [SQL-Query] ```
SELECT SUM(CASE WHEN T2.`Sales Team` = 'Adam Hernandez' THEN 1 ELSE 0 END) FROM `Sales Orders` AS T1 INNER JOIN `Sales Team` AS T2 ON T2.SalesTeamID = T1._SalesTeamID