Untitled

<?xml version=”1.0” encoding=”utf-8” ?>
	<hibernate-mapping xmlns=”urn:nhibernate-mapping-2.2”>
		<sql-query name=”GuitarValueByTypeSQL”>
			<![CDATA[
			SELECT G.TYPE, SUM(I.COST)
			FROM GUITAR G, INVENTORY I
			WHERE G.ID = I.TYPEID
			GROUP BY G.TYPE
			]]>
		</sql-query>
	</hibernate-mapping>