:インテリジェントコーディングアシスタント

-- Conduct an analysis of e-commerce website sales orders in September 2024.
SELECT  ds
        ,spu_id
        ,SUM(sales_amt) AS total_sales
        ,COUNT(DISTINCT order_id) AS total_orders
        ,COUNT(DISTINCT sku_id) AS total_skus
        COUNT(DISTINCT buyer_id) AS total_buyers
        COUNT(DISTINCT buyer_id) / COUNT(DISTINCT order_id) AS avg_buyers_per_order
        ,COUNT(DISTINCT buyer_id) / COUNT(DISTINCT sku_id)  AS avg_buyers_per_sku
        ,SUM(sales_amt) / COUNT(DISTINCT order_id) AS avg_sales_per_order
        ,SUM(sales_amt) / COUNT(DISTINCT sku_id) AS avg_sales_per_sku
FROM    default.dwd_ec_trd_create_ord_di
WHERE   order_date BETWEEN '2024-09-01' AND '2024-09-18'
ORDER BY total_sales DESC
LIMIT   10
;

-- Read sample data.
-- Open the MaxCompute three-layer model.
SET odps.namespace.schema = true
;

-- Make sure that the new implementation for data of the DECIMAL data type is used.
SET odps.sql.decimal.odps2 = true
;

SELECT  gross_regional_product -- Gross Regional Product (GRP) (CNY 100 million).
        ,value_added_of_the_primary_industry -- Value added of the primary industry (CNY 100 million). This refers to the market value of the final output of all resident units from primary-industry production activities in a country (or a region) during a period of time. The primary industry includes agriculture, forestry, animal husbandry, and fishery. 
        ,value_added_of_the_secondary_industry -- Value added of the second industry (CNY 100 million). This refers to the market value of the final output of all resident units from second-industry production activities in a country (or a region) during a period of time. The second industry includes mining, manufacturing, production and supply sector of electricity, gas, and water, and construction. 
        ,value_added_of_the_tertiary_industry -- Value added of the third industry (CNY 100 million). This refers to the market value of the final output of all resident units from third-industry production activities in a country (or a region) during a period of time. The third industry includes all sectors except the primary and second industries. 
        ,value_added_of_agriculture_forestry_animal_husbandry_and_fishery -- Value added of agriculture, forestry, animal husbandry, and fishery (CNY 100 million).
        ,value_added_of_industry -- Value added of industry (CNY 100 million). This refers to the final output of industrial enterprises from industrial production activities during the reporting period, expressed in monetary terms. 
        ,value_added_of_construction -- Value added of the construction industry (CNY 100 million). This refers to the final output of construction enterprises from production activities of the construction industry during the reporting period, expressed in monetary terms. 
        ,value_added_of_wholesale_and_retail_trades -- Value added of the wholesale and retail industries (CNY 100 million). This refers to the market value of the final output of all resident units from production activities of the wholesale and retail industries in a country (or a region) during a period of time. 
        ,value_added_of_transport_storage_and_post -- Value added of the transportation, warehousing, and post industries (CNY 100 million). This refers to the market value of the final output of all resident units from production activities of the transportation, warehousing, and post industries in a country (or a region) during a period of time. 
        ,value_added_of_hotels_and_catering_services -- Value added of the accommodation and catering industries (CNY 100 million). This refers to the market value of the final output of all resident units from production activities of the accommodation and catering industries in a country (or a region) during a period of time. 
        ,value_added_of_financial_intermediation -- Value added of the financial industry (CNY 100 million). This refers to the market value of the final output of all resident units from production activities of the financial industry in a country (or a region) during a period of time. 
        ,value_added_of_real_estate -- Value added of the real estate industry (CNY 100 million). This refers to the market value of the final output of all resident units from production activities of the real estate industry in a country (or a region) during a period of time. 
        ,value_added_of_others -- Value added of other industries (CNY 100 million). This refers to the market value of the final output of all resident units from production activities of other industries in a country (or a region) during a period of time. 
        ,per_capital_gross_regional_product -- GRP per capita (yuan/person). GRP per capita refers to the ratio of the absolute value of GRP to the average population of that year. It measures the economic contribution or value created by each resident in a country or region. 
        ,region -- the region. The enumeration includes the 31 provinces, municipalities, and autonomous regions in the Chinese mainland, such as Beijing, Zhejiang Province, and Inner Mongolia Autonomous Region. 
        ,year -- the year. The enumeration includes years from 2003 to 2022.
FROM    bigdata_public_dataset.life_service.mainland_gross_regional_product
WHERE   year IS NOT NULL
LIMIT   100
;