Extracting xml tags and values of clob data in a table : 	

One of my tables has a clob column with above data(as shown in the picture)
please help me with a query which results the number of rows which contain <location> tag.


  [1]: https://i.stack.imgur.com/zoiak.png