with xml_example(region, service, affinity, client, rating, subscribers) as (
  select 'East', 'TV',    'Primary',   'Legacy', 4, 7 from dual union all
  select 'West', 'Phone', 'Primary',   'New', 4, 7 from dual union all
  select 'West', 'Phone', 'Secondary', 'New', 4, 7 from dual union all
  select 'West', 'TV',    'Primary',   'New', 1, 5 from dual
)
select *
from xml_example

<?xml version="1.0"?>
<Data>
    <region>East
        <service>TV
            <affinity>Primary
                <client>Legacy
                    <rating>4</rating>
                    <subscribers>7</subscribers>
                </client>
            </affinity>
        </service>
    </region>
    <region>West
        <service>TV
            <affinity>Primary
                <client>New
                    <rating>1</rating>
                    <subscribers>5</subscribers>
                </client>
            </affinity>
        </service>
        <service>Phone
            <affinity>Primary
                <client>New
                    <rating>4</rating>
                    <subscribers>7</subscribers>
                </client>
            </affinity>
            <affinity>Secondary
                <client>New
                    <rating>4</rating>
                    <subscribers>7</subscribers>
                </client>
            </affinity>
        </service>
    </region>
</Data>