Shell API Endpoint Generator

def find_prime_numbers(limit):
    prime_numbers = [True] * (limit + 1)
    p = 2
    while (p * p <= limit):
        if (prime_numbers[p] == True):
            for i in range(p * p, limit+1, p):
                prime_numbers[i] = False
        p +=1
    return [p for p in range(2, limit) if prime_numbers[p]]

limit = 30
print(find_prime_numbers(limit))

WITH previous_asset_values AS (
    SELECT asset_id, MAX(value) OVER (PARTITION BY asset_id ORDER BY date ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) AS previous_value
    FROM asset_values
)
SELECT asset_id, value - previous_value AS value_change
FROM asset_values
JOIN previous_asset_values USING(asset_id)

SELECT OrderId, COUNT(DISTINCT ProductId)
FROM OrderDetails
GROUP BY OrderId
HAVING COUNT(DISTINCT ProductId) = 1

calculation <- function(x, y) {
    result <- sum(sapply(1:x, function(i) i*y))
    return(result)
}

calculation(10, 3)

private static int BinarySearch(int[] array, int target) {
    int left = 0;
    int right = array.length - 1;

    while (left <= right) {
        int mid = (left + right) / 2;

        if (array[mid] == target) return mid;

        if (array[mid] < target) left = mid + 1;
        else right = mid - 1;
    }

    return -1;
}

SELECT tutors, AVG(ratings) as average_rating, COUNT(*) as total_reviews
FROM (SELECT tutor_id as tutors, review_rating as ratings FROM Reviews) t
GROUP BY tutors
ORDER BY average_rating DESC, total_reviews DESC

import numpy as np


def binary_search(arr, target):
    low, high = 0, len(arr) - 1
    while low <= high:
        mid = low + (high - low) // 2
        if arr[mid] == target:
            return mid
        elif arr[mid] < target:
            low = mid + 1
        else:
            high = mid - 1
    return -1

cubeRoot = lambda x : x**(1/3) if x > 0 else -(-x)**(1/3)

EVALUATE
SUMMARIZE('Table1', 
'Table1'[Category],"Total Sales", SUM('Table1'[Sales]),"Average Sales", AVERAGE('Table1'[Sales]))
ORDER BY [Total Sales] DESC

SELECT DISTINCT ORDER_NUMBER, PRODUCT_CODE
FROM ORDER_ITEMS
WHERE ORDER_NUMBER IN(
    SELECT ORDER_NUMBER 
    FROM ORDERS
    WHERE CUSTOMER_CODE = 'ALFKI'
)
ORDER BY ORDER_NUMBER, PRODUCT_CODE