Google BigQuery Logic Visualizer

Python - Recursive function

def fibonacci(n):
    if n==1 or n==2:
        return 1
    else:
        return fibonacci(n-1) + fibonacci(n-2)

print(fibonacci(10))

SQL - Subqueries and Aggregate Functions

SELECT department, MAX(salary) FROM (SELECT department, SUM(salary) as salary FROM employees GROUP BY department) as total_salaries GROUP BY department

R - Vectorized operations

numbers <- c(1:10)
squares <- numbers^2

DAX - CALCULATE function with Filter context

Revenue Last Year = CALCULATE( SUM('Sales'[Revenue]), SAMEPERIODLASTYEAR('Calendar'[Date]))

Microsoft Excel - VLOOKUP with approximate match

=VLOOKUP(E2, A2:B15, 2, TRUE)

Python - List comprehension

squares = [x ** 2 for x in range(10)]

SQL - Inner Join

SELECT orders.order_id, customers.customer_name, shippers.shipper_name FROM ((orders INNER JOIN customers ON orders.customer_id = customers.customer_id) INNER JOIN shippers ON orders.shipper_id = shippers.shipper_id)

R - Apply functions

x <- matrix(rep(10,12), nrow=3)
apply(x, 2, function(x) { mean(x) })

DAX - CONCATENATEX function

Employee List = CONCATENATEX( Employees, Employees[Full Name], ", ", [Position], ASC)

Microsoft Excel - Conditional Formatting Rule

=IF(A1>100,"Green",IF(A1>50,"Yellow","Red"))