式の生成

Write a regex to standardize phone numbers by applying formatting logic to match the pattern (XXX) XXX-XXXX.

Create a condition to route separate records by month and assign them to different targets.

Check if address1 contains USA. If yes, concatenate address1 and address2. If not, convert the mod of the ASCII code of the first letter in both the city and state to string.

Extract the month from the start date and compare it to the end date.

1. Cast all columns to string. Do a left or right trim.
2. Make sure all fields aren't null.
3. If there's a null, replace it with null stringConcatenate all the above using the || operator and don't use the concat function.
4. Create an MD5 function out of the concatenated value.

Cast all columns to string. Do a left or right trim. Join all.

if order status is New or Processing and order date in January
set order status to Fulfilled
else if order date in February
set order status to Delayed

    // --- TIER 1: STRATEGIC & HIGH-GROWTH ---
    // Criteria: Very high revenue, large size, and an active client in a key industry.
    IF (Revenue >= 25,000,000 AND 
        NumberOfEmployees >= 5,000 AND
        (Industry == 'Technology' OR Industry == 'Financial Services') AND
        Type == 'Active Client') THEN
        
        Priority_Bucket = 'Tier 1 - Strategic & High-Growth'
    
    // --- TIER 2: KEY ACCOUNTS ---
    // Criteria: High revenue, significant size, OR an active client in any target industry.
    ELSE IF ((Revenue >= 10,000,000 AND 
              NumberOfEmployees >= 1,000) OR
             (Revenue >= 5,000,000 AND
              Type == 'Active Client' AND
              (Industry == 'Healthcare' OR Industry == 'Manufacturing'))) THEN

        Priority_Bucket = 'Tier 2 - Key Accounts'

    // --- TIER 3: STANDARD ACCOUNTS ---
    // Criteria: Established revenue, moderate size, typically a Prospect or long-term Client.
    ELSE IF (Revenue >= 1,000,000 AND 
             Revenue < 10,000,000 AND
             NumberOfEmployees >= 100 AND
             (Type == 'Client' OR Type == 'Prospect')) THEN

        Priority_Bucket = 'Tier 3 - Standard Accounts'

    // --- TIER 4: DEVELOPMENTAL ACCOUNTS ---
    // Criteria: Smaller, but strategic as a new Partner or a small company in a key industry.
    ELSE IF (Revenue >= 100,000 AND 
             NumberOfEmployees >= 50 AND
             (Industry == 'Technology' OR Type == 'Partner')) THEN

        Priority_Bucket = 'Tier 4 - Developmental Accounts'
    
    // --- TIER 5: SME/OTHER ---
    // Criteria: All remaining items.
    ELSE
        Priority_Bucket = 'Tier 5 - SME/Other'
    END IF

SELECT totalAmount,
CASE
WHEN TO_NUMBER(totalAmount) > 1000 THEN 'High Value'
ELSE 'Standard'
END AS amount_category
FROM your_table;