It is not possible, as the value "Avis" does not exist in the sample data
Strange I pasted it and it doesn't show in my post. I will pasting it again.
DECLARE @myDoc XML
DECLARE @ProdID VARCHAR(200)
SET @myDoc = '<?xml version="1.0" encoding="UTF-8"?>
<title lang="en"> Kick Start</title>
SELECT @myDoc.value('/bookstore/book/span/@class', 'varchar(200)')