John Lekberg

JUNTO is a club for cool kids.

Daniel runs next meeting: 2019-10-02, 6pm ET (5pm CT).

Current Practice Problem

Problem is "Ollivander's Inventory".

Hint: This query is looking for the cheapest wand for a given combination of age and power. In the WHERE clause of your query, use a subquery to make sure the it has the minimum coins needed compared to all other wands of the same age and power.

Old Practice Problems

• Placements - 2019-09-18
• Contest Leaderboard - 2019-09-05
• The PADS - 2019-08-15
• Hackerrank, "Employee Salaries" - 2019-07-24
• Hackerrank, "Revising the Select Query 1" - 2019-06-25
• Hackerrank, "Detect HTML Links" - 2019-06-11
• Hackerrank, "Detect the Domain Name" - 2019-05-22
• Hackerrank, "Detect the Email Addresses" - 2019-04-16
• Project Euler Problem 23 - 2019-04-04
• Project Euler Problem 102 - 2019-02-18
• Project Euler Problem 99 - 2019-01-21
• Project Euler Problem 35 - 2019-01-02
• Project Euler Problem 48 - 2018-12-19
• Project Euler Problem 44 - 2018-11-28
• Project Euler Problem 25 - 2018-11-08
• Project Euler Problem 11 - 2018-10-16
• Project Euler Problem 4 - 2018-10-01
• Project Euler Problem 1 - 2018-09-18
• Rosalind, Complementing a Strand of DNA - 2018-09-04
• Project Euler Problem 22 - 2018-08-20

Log

A log of past information.

Marketwatch Games

• JUNTO 9 - 2019-05-28/06-04 - technical justification for trades
  1. John - $99,167.14
• JUNTO 8 - 2019-04-17/30 - technical justification for trades
  1. John - $95,445.10
• JUNTO 7 - 2019-04-04/17 - shorts only, technical justification for trades
  1. John - $102,882.12
  2. Oscar - $99,215.00
• JUNTO 6 - 2019-04-01/03 - shorts only
  1. Daniel - $102,912.64
  2. Oscar - $100,538.55
  3. John - $99,957.85
• JUNTO 5 - 2019-03-08/19 - shorts only
  1. John - $101,859.27
  2. Oscar - $101,194.54
  3. Daniel - $100,298.00
• JUNTO 4 - 2019-02-19/03-04
  1. John - $101,198.40
  2. Oscar - $100,438.37
  3. Daniel - $99,653.65
• JUNTO 3 - 2019-02-05/18
  1. John - $108,981.80
  2. Daniel - $99,297.04
• JUNTO 2 - 2019-01-23/02-04
  1. Daniel - $100,602.64
  2. John - $99,763.28
  3. Oscar - $98,639.89
• JUNTO
  1. Daniel - $979,727.85
  2. Cai - $977,569.63
  3. John - $884,379.43
  4. Oscar - $883,881.90