Hacker Newsnew | past | comments | ask | show | jobs | submit | rexpan's commentslogin

My SQL Solution (SQL Server)

    -- Create Table #x(v) from 1..99
    WITH x AS (SELECT n FROM (VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) v(n))
    SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS v INTO #x 
    FROM x ones, x tens ORDER BY 1
    ;
    DELETE FROM #x WHERE v > 99
    ;
    -- Create Candidate #c(x, y, s, p) with pair (x,y) (x <= y) and sum `s` and product `p`
    SELECT x.v AS x, y.v AS y, x.v + y.v AS s, x.v \* y.v AS p INTO #c FROM #x x, #x y WHERE x.v <= y.v
    ;
    -- Peter: I don’t know the numbers.
    DELETE FROM #c WHERE p IN (SELECT p FROM (SELECT p, COUNT(*) AS n FROM #c GROUP BY p) AS d WHERE n < 2)
    -- Sandy: I don’t know the numbers.
    DELETE FROM #c WHERE s IN (SELECT s FROM (SELECT s, COUNT(*) AS n FROM #c GROUP BY s) AS d WHERE n < 2)
    -- Peter: I don’t know the numbers.
    DELETE FROM #c WHERE p IN (SELECT p FROM (SELECT p, COUNT(*) AS n FROM #c GROUP BY p) AS d WHERE n < 2)
    -- Sandy: I don’t know the numbers.
    DELETE FROM #c WHERE s IN (SELECT s FROM (SELECT s, COUNT(*) AS n FROM #c GROUP BY s) AS d WHERE n < 2)
    -- Peter: I don’t know the numbers.
    DELETE FROM #c WHERE p IN (SELECT p FROM (SELECT p, COUNT(*) AS n FROM #c GROUP BY p) AS d WHERE n < 2)
    -- Sandy: I don’t know the numbers.
    DELETE FROM #c WHERE s IN (SELECT s FROM (SELECT s, COUNT(*) AS n FROM #c GROUP BY s) AS d WHERE n < 2)
    -- Peter: I don’t know the numbers.
    DELETE FROM #c WHERE p IN (SELECT p FROM (SELECT p, COUNT(*) AS n FROM #c GROUP BY p) AS d WHERE n < 2)
    -- Sandy: I don’t know the numbers.
    DELETE FROM #c WHERE s IN (SELECT s FROM (SELECT s, COUNT(*) AS n FROM #c GROUP BY s) AS d WHERE n < 2)
    -- Peter: I don’t know the numbers.
    DELETE FROM #c WHERE p IN (SELECT p FROM (SELECT p, COUNT(*) AS n FROM #c GROUP BY p) AS d WHERE n < 2)
    -- Sandy: I don’t know the numbers.
    DELETE FROM #c WHERE s IN (SELECT s FROM (SELECT s, COUNT(*) AS n FROM #c GROUP BY s) AS d WHERE n < 2)
    -- Peter: I don’t know the numbers.
    DELETE FROM #c WHERE p IN (SELECT p FROM (SELECT p, COUNT(*) AS n FROM #c GROUP BY p) AS d WHERE n < 2)
    -- Sandy: I don’t know the numbers.
    DELETE FROM #c WHERE s IN (SELECT s FROM (SELECT s, COUNT(*) AS n FROM #c GROUP BY s) AS d WHERE n < 2)
    -- Peter: I don’t know the numbers.
    DELETE FROM #c WHERE p IN (SELECT p FROM (SELECT p, COUNT(*) AS n FROM #c GROUP BY p) AS d WHERE n < 2)
    -- Sandy: I don’t know the numbers.
    DELETE FROM #c WHERE s IN (SELECT s FROM (SELECT s, COUNT(*) AS n FROM #c GROUP BY s) AS d WHERE n < 2)
    -- Peter: I do know the numbers.
    SELECT * FROM #c WHERE p IN (SELECT p FROM (SELECT p, COUNT(*) AS n FROM #c GROUP BY p) AS d WHERE n < 2)
    /*
    x y s p
    77 84 161 6468
    */


It's not pretty, but it works!


These 3 functions will stop on `await event.xxx` (if not, they will continue to execute or terminate). So when one of the functions is terminate https://github.com/pdubroy/handling-user-input/blob/main/abr...

   await Promise.any(fibers.map((f) => f.run()));
   fibers.forEach((f) => f.terminate());
Abro will reject the promise of these `await event.xxx` https://github.com/pdubroy/handling-user-input/blob/main/abr...

    this._promises.forEach(({ reject }) => reject());
Which will throw an Exception and exit the 2 other functions.


Yup, it is gatsby. https://github.com/gaearon/overreacted.io

You can use https://overreacted.io/rss.xml for subscription.


> It maps every tree to a natural number, but not every natural number to a tree.

This is a one-to-one mapping between binary trees and natural numbers.

This encode an n level tree with O(n) bits


Set

"telemetry.enableTelemetry": false

In Preference > Settings


My favorites:

- `F7`: no more inaccuracy Ctrl+D symbol navigation

- Auto Import


Format > Font > Advanced > Use Contextual Alternates

https://github.com/aftertheflood/spark#using-atf-spark-in-ms...


React, AngularJS v1, basically everything that more than 100 lines of js code.


I think the current design fine. I mainly work on the desktop and want to gather much things to process. Waiting in the line to try this out.


Thank you for comment!


You should try [this](https://chrome.google.com/webstore/detail/high-contrast/djcf...) if you use Chrome.


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: