Skip to content

Instantly share code, notes, and snippets.

View will-fong's full-sized avatar
🏠
Working from home

Will Fong will-fong

🏠
Working from home
View GitHub Profile

What I Wish I'd Known About Equity Before Joining A Unicorn

Disclaimer: This piece is written anonymously. The names of a few particular companies are mentioned, but as common examples only.

This is a short write-up on things that I wish I'd known and considered before joining a private company (aka startup, aka unicorn in some cases). I'm not trying to make the case that you should never join a private company, but the power imbalance between founder and employee is extreme, and that potential candidates would

@will-fong
will-fong / Codewars-CASE.sql
Last active September 18, 2021 07:31
Submissions for Codewars Katas
/*
https://www.codewars.com/kata/593ef0e98b90525e090000b9
SQL Basics - Monsters using CASE
*/
SELECT top.*
,bot.*
,CASE
WHEN top.heads > top.arms THEN 'BEAST'
WHEN bot.tails > bot.legs THEN 'BEAST'
ELSE 'WEIRDO'
#! /usr/bin/env python
# -*- coding: utf-8 -*-
"""This module's docstring summary line.
This is a multi-line docstring. Paragraphs are separated with blank lines.
Lines conform to 79-column limit.
Module and packages names should be short, lower_case_with_underscores.
Notice that this in not PEP8-cheatsheet.py
@will-fong
will-fong / .HackerRank - Exercises.md
Last active August 8, 2024 16:26
Submissions for HackerRank

HackerRank - Python Exercises

Python

  • Athlete Sort.py
  • Finding the percentage.py
  • ginortS.py
  • Re.start() & Re.end().py
  • Reduce Function.py
  • Regex Substitution.py
  • String Split and Join.py
@will-fong
will-fong / Exercise 13.10.dax
Last active August 24, 2021 23:22
Mastering DAX
--https://dax.do/HjDPEEQlk8ADkj
--13.10 - Sales by year
EVALUATE
SUMMARIZECOLUMNS (
'Date'[Calendar Year],
"Sales", [Sales Amount],
"Pct",
DIVIDE (
[Sales Amount],
CALCULATE ( [Sales Amount], ALL ( 'Date'[Calendar Year] ) )
@will-fong
will-fong / .Oracle Live SQL.md
Last active June 16, 2023 15:52
Oracle Live SQL

SQL Exercises

Databases for Developers

  • Analytic Functions - Databases for Developers.sql
  • Creating Tables: Databases for Developers.sql
  • Introduction to SQL.sql
  • Subqueries - Databases for Developers.sql
@will-fong
will-fong / Salary Negotiation in Tech.md
Created September 18, 2021 07:27
Salary Negotiation in Tech

Advice for those seeking salary increases

Many people, especially tech people - have a difficult time asking for raises. It is just not part of the typical personality trait of a very smart but often introverted person. Many of us are taught to be humble, even meek, from a very young age. Of course, too much of a good thing can be a bad thing. I'm mid-career and have alot of serious bills. I've been with my company for a long time, but struggled with whether or not to leave, ask for a raise, etc. I went four years without a cost of living increase, before I got up the nerve to ask. Am I already making too much? Will I be fired for asking? Salaries are the most tightly kept secrets. I know about guys cheating on their wives and with who. I don't know what ANYONE in my company makes.

>I desperately wanted to know what people made, so I could know where I stood - if I should leave and when applying to other jobs, feel good about asking and what I expected to get paid. In fact I was almost obse

@will-fong
will-fong / Interview-Exercises.sql
Created September 20, 2021 06:19
Jitbit's SQL interview questions
CREATE TABLE `department` (
`id` INT UNSIGNED NOT NULL PRIMARY KEY,
`name` VARCHAR(30)
);
CREATE TABLE `employee` (
`id` INT UNSIGNED NOT NULL PRIMARY KEY,
`name` VARCHAR(30),
`salary` INT UNSIGNED,
`boss_id` INT UNSIGNED DEFAULT NULL,

New Year Gift - Curated List of Top 75 LeetCode Questions to Save Your Time

Facebook / Eng tech lead

140 Comments

New Year Gift to every fellow time-constrained engineer out there looking for a job, here's a list of the best LeetCode questions that teach you core concepts and techniques for each category/type of problems! Many other LeetCode questions are a mash of the techniques from these individual questions. I used this list in my last job hunt to only do the important questions.

Good luck and Happy New Year!

Array

@will-fong
will-fong / .LeetCode SQL Exercises.md
Last active September 23, 2021 05:13
LeetCode SQL Exercises

SQL Exercises

Difficulty

Hard

Medium