Have a try with something like the following example:
declare @tallyXML as xml
set @tallyXML = '<USAGE>
<Customer>ABC</Customer>
<Age>38</Age>
<Mobile>
<Model>Nokia</Model>
<Price>100</Price>
</Mobile>
<Mobile>
<Model>Samsung</Model>
<Price>300</Price>
</Mobile>
</USAGE>'
SELECT CustTable.Mobile.value('../Customer[1]','varchar(100)') AS 'Customer',
CustTable.Mobile.value('../Age[1]','varchar(100)') AS 'Age',
CustTable.Mobile.value('./Model[1]','varchar(100)') AS 'Model',
CustTable.Mobile.value('./Price[1]','varchar(100)') AS 'Price'
FROM @tallyXML.nodes('USAGE/Mobile') as CustTable(Mobile)