Explanation:

Box 1: Yes
For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS).
Box 2: No
Box 3: Yes
Box 4: Yes
Azure Cosmos DB supports multi-region writes.
Reference:
https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy
https://manojchoudhari.wordpress.com/2019/12/16/azure-cosmos-db-enable-multi-region-writes

See the answer in explanation below.
Explanation:
Answer below as:

Explanation:

Disadvantages of non-relational databases include: Data Consistency - non-relational databases do not perform ACID transactions.
Note: Relational databases are optimized for writes. They are optimized for consistency and availability.
Advantages of relational databases include simplicity, ease of data retrieval, data integrity, and flexibility.
Reference:
https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77

Explanation:

Box 1: SELECT
Box 2: GROUP BY
Example:
When used with a GROUP BY clause, each aggregate function produces a single value covering each group, instead of a single value covering the whole table. The following example produces summary values for each sales territory in the AdventureWorks2012 database. The summary lists the average bonus received by the sales people in each territory, and the sum of year-to-date sales for each territory.
SELECT TerritoryID, AVG(Bonus)as 'Average bonus', SUM(SalesYTD) as 'YTD sales' FROM Sales.SalesPerson GROUP BY TerritoryID; Reference:
https://docs.microsoft.com/en-us/sql/t-sql/functions/avg-transact-sql