Data Structure Designer

def quicksort(arr):
    if len(arr) <= 1:
        return arr
    pivot = arr[len(arr) // 2]
    left = [x for x in arr if x < pivot]
    middle = [x for x in arr if x == pivot]
    right = [x for x in arr if x > pivot]
    return quicksort(left) + middle + quicksort(right)

SELECT a.ViewCount, b.Reputation
FROM Users b
JOIN Posts a ON a.OwnerUserId = b.Id
WHERE b.Reputation > 10000
ORDER BY a.ViewCount DESC

import numpy as np
import pandas as pd
s = pd.Series([1,3,5,np.nan,6,8])
dates = pd.date_range('20130101', periods=6)
df = pd.DataFrame(np.random.randn(6,4), index=dates, columns=list('ABCD'))

let asyncFunction = async function() {
    let result = await doSomething();
    let nextResult = await doSomethingElse(result);
    let finalResult = await doAnotherThing(nextResult);
    return finalResult;
};

fun Long.factorial(): Long {
    return if (this == 0L) 1L else this * (this - 1).factorial()
}
fun main() {
    val fiveFactorial = 5L.factorial()
    println("5! = $fiveFactorial")
}

using System;
using System.Linq;
public class Hello {
    public static void Main() {
        var data = new [] { 1, 2, 3, 4, 5 };
        var filteredData = data.Where(x => x > 3).Select(x => x * 2);
        Console.WriteLine(String.Join(", ", filteredData));
    }
}

=SUMPRODUCT((A1:A10>B1:B10)*(C1:C10))

EVALUATE
SUMMARIZECOLUMNS('Date'[Year], "Total Sales", SUM('Sales'[Sales Amount]))

class MyDescriptor:
    def __get__(self, instance, owner):
        return 42

class MyClass:
    x = MyDescriptor()

obj = MyClass()
print(obj.x)

let items = [1, 2, 3, 4, 5]
let results = items.map { $0 * 2 }.filter { $0 % 2 == 0 }.reduce(0, +)
print(results)