Skip to content

Instantly share code, notes, and snippets.

View florestankorp's full-sized avatar
🇳🇱
Frontend Dev

Florestan Korp florestankorp

🇳🇱
Frontend Dev
View GitHub Profile
import sqlite3
import sys
def main():
if len(sys.argv) < 2:
print("I")
return
-- Write a SQL query to list the titles of the five highest rated movies
-- (in order) that Chadwick Boseman starred in, starting with the highest rated.
-- Your query should output a table with a single column for the title of each movie.
-- You may assume that there is only one person in the database with the name
-- Chadwick Boseman.
SELECT title, rating
FROM movies
JOIN ratings on movies.id = ratings.movie_id
JOIN stars on movies.id = stars.movie_id
@florestankorp
florestankorp / best-books.js
Created January 29, 2020 13:53
Mapping an array to object with default keys
const BOOKS = [
'1',
'The Stranger\nThe Outsider',
'Albert Camus',
'1942',
'French',
'2',
'In Search of Lost Time\nRemembrance of Things Past',
'Marcel Proust',
'1913–27',
function myReplace(str, before, after) {
let index = str.indexOf(before);
if (str[index] === str[index].toUpperCase()) {
after = `${after[0].toUpperCase()}${after.slice(1)}`;
}
return str.replace(before, after)
}
/*
You Don't Know JS: Up & Going
Chapter 1: Into Programming - PRACTICE
https://github.com/getify/You-Dont-Know-JS/blob/master/up%20%26%20going/ch1.md
*/
let accountBalance = 303.91;
let totalPriceOfPurchase = 0;
const TAX_RATE = 0.08;
@florestankorp
florestankorp / cloudSettings
Last active September 23, 2018 15:48
Visual Studio Code Settings Sync Gist
{"lastUpload":"2018-09-23T15:48:08.286Z","extensionVersion":"v3.1.2"}
@florestankorp
florestankorp / cloudSettings
Created September 20, 2018 10:15
Visual Studio Code Settings Sync Gist
{"lastUpload":"2018-09-20T10:15:10.101Z","extensionVersion":"v3.1.2"}