How do I write a unit test query for this mapping document?

This is the mapping document

I was asked to write a "unit test" for testing this mapping document. Did I do the query correctly?

I have multiple select statements and I'm not sure if I'm doing this correctly. I have a select statement for each of the rows in the mapping document.

Am I doing this "unit test" correctly?

SELECT agreement_id
FROM event JOIN agreement_event
ON event.event_id = agreement_event.event_id
WHERE event_activity_type_cd = 'update_address_phone_number'

SELECT data_source_type_cd
FROM event JOIN agreement_event
ON event.event_id = agreement_event.event_id
WHERE event_activity_type_cd = 'update_address_phone_number'

SELECT rc
FROM event JOIN agreement_event
ON event.event_id = agreement_event.event_id
WHERE event_activity_type_cd = 'update_address_phone_number'

SELECT channel
FROM event JOIN agreement_event
ON event.event_id = agreement_event.event_id
WHERE event_activity_type_cd = 'update_address_phone_number'

SELECT sub_channel
FROM event JOIN agreement_event
ON event.event_id = agreement_event.event_id
WHERE event_activity_type_cd = 'update_address_phone_number'

SELECT event_start_dttm
FROM event JOIN agreement_event
ON event.event_id = agreement_event.event_id
WHERE event_activity_type_cd = 'update_address_phone_number'

SELECT event_subtype_cd
FROM event JOIN agreement_event
ON event.event_id = agreement_event.event_id
WHERE event_activity_type_cd = 'update_address_phone_number'SELECT agreement_id

SELECT event_activity_type_cd
FROM event JOIN agreement_event
ON event.event_id = agreement_event.event_id
WHERE event_activity_type_cd = 'update_address_phone_number'

SELECT event_desc
FROM event JOIN agreement_event
ON event.event_id = agreement_event.event_id

SELECT employeeid
FROM event JOIN agreement_event
ON event.event_id = agreement_event.event_id
WHERE event_activity_type_cd = 'update_address_phone_number'
WHERE event_activity_type_cd = 'update_address_phone_number'

FROM event JOIN agreement_event
ON event.event_id = agreement_event.event_id
WHERE event_activity_type_cd = 'update_address_phone_number'