R Exception Handler

def fibonacci(n):
    if n<=0:
        return 'Input number should be positive integers only'
    elif n==1:
        return 0
    elif n==2:
        return 1
    else:
        return fibonacci(n-1) + fibonacci(n-2)

SELECT s.name AS schema_name, o.name AS table_name, c.name AS column_name
FROM sys.columns c
INNER JOIN sys.objects o ON c.object_id = o.object_id
INNER JOIN sys.schemas s ON o.schema_id = s.schema_id
WHERE c.name LIKE '%ID%'
ORDER BY schema_name, table_name, column_name;

avg <- function(x) {
    sum1 <- sum(x)
    length1 <- length(x)
    mean1 <- sum1 / length1
    return(mean1)
}

EVALUATE 
FILTER('Sales', 
     'Sales'[Year] = "2020" && 'Sales'[Country] = "Japan" 
&& 'Sales'[Category] = "Technology" 
&& 'Sales'[Sub-Category] = "Accessories" 
&& 'Sales'[Discount] >= 0.2)

=SUMPRODUCT(--(A1:A10>=LOWER_LIMIT),--(A1:A10<=UPPER_LIMIT),B1:B10)

def my_decorator(func):
    def wrapper(*args, **kwargs):
        print('Before function execution')
        result = func(*args, **kwargs)
        print('After function execution')
        return result
    return wrapper

@my_decorator
def suma(x, y):
    return x + y

print(suma(5, 10))

CREATE OR REPLACE PROCEDURE process_orders()
BEGIN
    FOR order_rec IN (SELECT order_id FROM orders WHERE status = 'pending') LOOP
        UPDATE orders
        SET status = 'processed'
        WHERE order_id = order_rec.order_id;
    END LOOP;
    COMMIT;
END process_orders;

dense_ranking <- function(x) {
    duplicate_num <- dups(x)
    unique_num <- unique(x)
    sorted_kernel <- sort(unique_num)

    if(length(duplicate_num) > 0) {
        dups_ranking <- match(duplicate_num, sorted_kernel)
        return(dups_ranking)
    } else {
        sorted_ranking <- match(x, sorted_kernel)
        return(sorted_ranking)
    }
}

EVALUATE 
SUMMARIZECOLUMNS (
'Products'[categories], "TotalUnitsSold", SUM('Sales'[Units Sold]), 
"TotalSalesValue", SUM('Sales'[Sales Price])*SUM('Sales'[Units Sold]) 
)

=SUMIFS(C2:C10,B2:B10,"<="&DATE(E2,12,31),B2:B10,">="&DATE(E2,1,1))