SELECT 
 * 
 
FROM 
 `sale` 
 
WHERE 
 JSON_VALUE( `data` , "$.amount" ) = :amount 
 
AND 
 `email` = :email