DRAG DROPContoso has an Azure DocumentDB database that contains contact information for customers.
You have a collection named Companies. The collection includes the following data:
You plan to collect the following information for contacts that are located in the South region only:
Company name
Given name
Surname
You need to create the query.
Which three Transact-SQL segments should you use to develop the solution? To answer, move the appropriate
Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.
Select and Place:
Answer: 
SELECT c.Name, c.contacts.givenName, c.contacts.surName
FROM Companies c
WHERE c.contracts.regions.regionName = ‘South’
SELECT c.Name, c.contacts.givenName, c.contacts.surName
FROM Companies c
WHERE c.contracts.regions.regionName = ‘South’
Learn more from this link –
https://sqlwithmanoj.com/2015/11/01/reading-json-string-with-nested-elements-sql-server-2016-part-3/