SQL Code Visualizer

def python_decorator(decorator_arg):
    def decorator_fun(func):
        def wrapper(*args, **kwargs):
            print(f'Before call {decorator_arg}')
            result = func(*args, **kwargs)
            print(f'After call {decorator_arg}')
            return result
        return wrapper
    return decorator_fun

@python_decorator('decorating')
    def print_args(*args):
        for arg in args:
            print(arg)

SELECT EmployeeID, FirstName, LastName, HireDate, YEAR(HireDate) as HireYear FROM Employees WHERE HireYear > 1998;

x <- c(1,2,3,4,5,NA)
processed_x <- ifelse(is.na(x), mean(x, na.rm = TRUE), x)

EVALUATE SUMMARIZE(Customers, [CustomerName], "Total Sales", SUM([SalesAmount]))

=VLOOKUP(A2,$E$2:$G$26,3,FALSE)

list_of_tuples = [(1, 'a'), (2, 'b'), (3, 'c')]
list_as_dict = {i: j for i, j in list_of_tuples}

SELECT TOP 5 (CustomerID), COUNT(OrderID) AS NumberOfOrders FROM Orders GROUP BY CustomerID

library(dplyr)
iris %>% select(Species, everything())

IFERROR(VLOOKUP(H5,$B$5:$C$1048576,2,FALSE), "No Match Found")

[i**2 for i in range(10) if i%2==0]