SQL Complexity Estimator

public class Fibonacci { static int fib(int n) { double phi = (1 + Math.sqrt(5)) / 2; return (int) Math.round(Math.pow(phi, n) / Math.sqrt(5)); } public static void main(String args[]) { int n = 9; System.out.println(fib(n)); } }

SELECT SUM(quantity) OVER (PARTITION BY product_id ORDER BY order_date RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS running_total FROM sales;

int x = 500, y = 1000, bin1, bin2, count = 16; while (count-- > 0) { bin1 = ((x & (1 << count) ) != 0) ? 1 : 0; bin2 = ((y & (1 << count) ) != 0) ? 1 : 0; write(bin1); write(bin2); };

def merge_sort(arr): if len(arr) > 1: mid = len(arr) // 2; Left = arr[:mid]; Right = arr[mid:]; merge_sort(Left); merge_sort(Right); i = j = k = 0; while i < len(Left) and j < len(Right): if Left[i] < Right[j]: arr[k] = Left[i]; i += 1; else: arr[k] = Right[j]; j += 1; k += 1; while i < len(Left): arr[k] = Left[i]; i += 1; k += 1; while j < len(Right): arr[k] = Right[j]; j += 1; k += 1; nums = [38, 27, 43, 3, 9, 82, 10]; merge_sort(nums); print(nums)

SELECT name AS 'Name', salary AS 'Employee Salary' FROM employee e WHERE 5= ( SELECT COUNT(DISTINCT salary) FROM employee e1 WHERE e1.salary >= e.salary ) ORDER BY salary DESC;

let validJSON = JSON.parse('{"name":"John", "age":30, "city":"New York"}'); let invalidJSON = JSON.parse('{name:John, age:30, city:New York}');

import asyncio; import time; async def myCoroutine(i): time.sleep(1); print('Coroutine ', i); async def main(): coroutines = [myCoroutine(i) for i in range(5)]; await asyncio.wait(coroutines); loop = asyncio.get_event_loop(); loop.run_until_complete(main()); loop.close();

public class DeadlockDemo { public static Object Lock1 = new Object(); public static Object Lock2 = new Object(); public static void main(String args[]) { ThreadDemo1 T1 = new ThreadDemo1(); ThreadDemo2 T2 = new ThreadDemo2(); T1.start(); T2.start(); } private static class ThreadDemo1 extends Thread { public void run() { synchronized (Lock1) { System.out.println("Thread 1: Holding lock 1..."); try { Thread.sleep(10); } catch (InterruptedException e) {} System.out.println("Thread 1: Waiting for lock 2..."); synchronized (Lock2) { System.out.println("Thread 1: Holding lock 1 & 2..."); } } } } private static class ThreadDemo2 extends Thread { public void run() { synchronized (Lock2) { System.out.println("Thread 2: Holding lock 2..."); try { Thread.sleep(10); } catch (InterruptedException e) {} System.out.println("Thread 2: Waiting for lock 1..."); synchronized (Lock1) { System.out.println("Thread 2: Holding lock 1 & 2..."); } } } } }

library(stringr); s = 'Hello, this is an R string example'; substring(s, first = 8, last = 11); str_sub(s, start = -6, end = -1); str_replace_all(string = s, pattern = '[aeiou]', replacement = '*');

=IFERROR(VLOOKUP(B2,Sheet2!$A$2:$C$5,2,FALSE),"No Match Found")