The following query was provided in the content for the subquery module. Using the terms presented in the module, in as much detail as possible, explain the following SQL code. 

b) Is this the best methodology to make this query? Provide your opinion after reviewing the source documentation (the document in the module)

 

Transcribed Image Text:

ESELECT [ModelName] FORMAT([Canada Totals]/[Model Totals], 'p2'), '') as [Canada %] [Model Totals] FROM 3 IIF([Australia Totals]>0 FORMAT ( [Australia Totals]/[Model Totals], 'p2'), ') as [Australia %] IIF ([Canada Totals]>0 SELECT ([Australia Totals] + [Canada Totals]) as [Model Totals] Level 2 FROM ( Subquery SELECT [ModelName] (SELECT CONVERT (Decimal, ISNULL(SUM([Product Totals]), 0)) FROM [featherman]. [BikeSales_Australia] as a WHERE a. [ModelName] = m. [ModelName]) as [Australia Totals] 3 Top level Subquery 3 (SELECT CONVERT (Decimal, ISNULL(SUM ( [Product Totals]), 0)) FROM [featherman].[BikeSales_Canada] as a WHERE a. [ModelName] = m. [ModelName]) as [Canada Totals] FROM [Featherman_Analytics]. [dbo]. [ModelNames] as m WHERE [ModelName] 'Touring-Panniers' AND [ModelName] LIKE '%Touring -%' OR [ModelName] LIKE '%Mountain-%' OR [ModelName] LIKE '%Road-%' sub ) sub2 Level 1 Subquery ESELECT [ModelName] FORMAT([Canada Totals]/[Model Totals], 'p2'), '') as [Canada %] [Model Totals] FROM 3 IIF([Australia Totals]>0 FORMAT ( [Australia Totals]/[Model Totals], 'p2'), ') as [Australia %] IIF ([Canada Totals]>0 SELECT ([Australia Totals] + [Canada Totals]) as [Model Totals] Level 2 FROM ( Subquery SELECT [ModelName] (SELECT CONVERT (Decimal, ISNULL(SUM([Product Totals]), 0)) FROM [featherman]. [BikeSales_Australia] as a WHERE a. [ModelName] = m. [ModelName]) as [Australia Totals] 3 Top level Subquery 3 (SELECT CONVERT (Decimal, ISNULL(SUM ( [Product Totals]), 0)) FROM [featherman].[BikeSales_Canada] as a WHERE a. [ModelName] = m. [ModelName]) as [Canada Totals] FROM [Featherman_Analytics]. [dbo]. [ModelNames] as m WHERE [ModelName] 'Touring-Panniers' AND [ModelName] LIKE '%Touring -%' OR [ModelName] LIKE '%Mountain-%' OR [ModelName] LIKE '%Road-%' sub ) sub2 Level 1 Subquery

Answer rating: 100% (QA)

The SQL query shown in the image is a nested subquery also known as a subquery within a subquery It is using a combination of SQL functions and conditional statements to retrieve and transform data fr... View the full answer