Commits

Breadcrumbs

History for

onmain

User selector

All users

All time

Commit history

Commits on Mar 4, 2026

• Docs: Refine Pandas copy=False/ROUND caveats and PostgreSQL FILTER/HashAgg claims

  myoshi2891

  committed
  b9d2003

  Copy full SHA for b9d2003

• Docs: Fix Python deduplication and precision details, PostgreSQL WHERE and index plan context

  myoshi2891

  committed
  157ffd7

  Copy full SHA for 157ffd7

• Docs: Update PostgreSQL doc to clarify float8 vs NUMERIC precision tradeoffs and benchmark noise

  myoshi2891

  committed
  145df53

  Copy full SHA for 145df53

• Fix: Correct Mermaid flowchart edge for poor_query_percentage calculation without NUMERIC cast

  myoshi2891

  committed
  206cc54

  Copy full SHA for 206cc54

• Fix: Restore WHERE clause and correct FLOAT cast explanation in PostgreSQL solution

  myoshi2891

  committed
  a61e983

  Copy full SHA for a61e983

• Add SQL/1211. Queries Quality and Percentage (Claude Sonnet 4.6 Extended)

  Show description for 90b00e9
  myoshi2891

  committed
  90b00e9

  Copy full SHA for 90b00e9

Commits on Feb 20, 2026

• fix(a11y): update SVG accessibility attributes and prismjs offline assets

  myoshi2891

  committed
  55520c4

  Copy full SHA for 55520c4

• style: fix double indent and final result generation format in Pow(x,n) html and pandas notes

  myoshi2891

  committed
  78233d6

  Copy full SHA for 78233d6

• docs: apply code review feedback for Exponentiation and SQL Reformat Department Table

  myoshi2891

  committed
  f150ea6

  Copy full SHA for f150ea6

• docs: adjust SVG viewBox and marker refX, fix pandas dropna explanation

  myoshi2891

  committed
  57e86f5

  Copy full SHA for 57e86f5

• docs: add 1179. Reformat Department Table solution

  myoshi2891

  committed
  38fc29f

  Copy full SHA for 38fc29f

Commits on Dec 5, 2025

• SQL: Basic Select 1148. Article Views I

  myoshi2891

  committed
  7ec4a5b

  Copy full SHA for 7ec4a5b

Commits on Dec 2, 2025

• SQL: Basic Select 1141. User Activity for the Past 30 Days I

  myoshi2891

  committed
  414cd40

  Copy full SHA for 414cd40

Commits on Nov 12, 2025

• SQL: Basic Select 1050. Actors and Directors Who Cooperated At Least Three Times

  myoshi2891

  committed
  ddf869d

  Copy full SHA for ddf869d

Commits on Nov 7, 2025

• SQL: Leetcode 626. Exchange Seats Intermediate Select

  myoshi2891

  committed
  1cca424

  Copy full SHA for 1cca424

Commits on Nov 6, 2025

• SQL: 620. Not Boring Movies Basic Select

  myoshi2891

  committed
  f1fcdb9

  Copy full SHA for f1fcdb9

Commits on Nov 4, 2025

• SQL: Basic Select 619. Biggest Single Number

  myoshi2891

  committed
  fc38f6a

  Copy full SHA for fc38f6a

Commits on Nov 2, 2025

• Math: Algebra Triangle Numbers 三項和三角形

  myoshi2891

  committed
  dcdcd04

  Copy full SHA for dcdcd04

• SQL: Basic Select 610. Triangle Judgement

  myoshi2891

  committed
  4ee3c56

  Copy full SHA for 4ee3c56

Commits on Nov 1, 2025

• SQL: Select Basic 608. Tree Node

  myoshi2891

  committed
  b81786e

  Copy full SHA for b81786e

Commits on Oct 31, 2025

• SQL: Basic Select 602. Friend Requests II: Who Has the Most Friends

  myoshi2891

  committed
  79d8477

  Copy full SHA for 79d8477

Commits on Oct 28, 2025

• SQL: Basic Select 596. Classes With at Least 5 Students

  myoshi2891

  committed
  5323785

  Copy full SHA for 5323785

Commits on Oct 27, 2025

• SQL: Basic Select 595. Big Countries

  myoshi2891

  committed
  151ddc7

  Copy full SHA for 151ddc7

Commits on Oct 24, 2025

• SQL: Basic select 586. Customer Placing the Largest Number of Orders

  myoshi2891

  committed
  d9194ef

  Copy full SHA for d9194ef

Commits on Oct 23, 2025

• SQL: Basic SQL 585. Investments in 2016

  myoshi2891

  committed
  55105a6

  Copy full SHA for 55105a6

Commits on Oct 22, 2025

• SQL: Basic select 584. Find Customer Referee

  myoshi2891

  committed
  894ea0f

  Copy full SHA for 894ea0f

• Setting for jupyter notebook

  myoshi2891

  committed
  e4d867c

  Copy full SHA for e4d867c

Commits on Oct 20, 2025

• SQL: Basic Select 570. Managers with at Least 5 Direct Reports

  myoshi2891

  committed
  682e517

  Copy full SHA for 682e517

Commits on Oct 18, 2025

• SQL:Basic select 550. Game Play Analysis IV

  myoshi2891

  committed
  b4deb4d

  Copy full SHA for b4deb4d

Commits on Oct 17, 2025

• Math: Fundamental Hacker Rank Army Game

  myoshi2891

  committed
  5d7baec

  Copy full SHA for 5d7baec

• SQL: leetcode 511. Game Play Analysis I Basic Select

  myoshi2891

  committed
  215f9b9

  Copy full SHA for 215f9b9

Commits on Oct 15, 2025

• Reviewed by coderabbit

  myoshi2891

  committed
  5580f3a

  Copy full SHA for 5580f3a

• SQL: 197. Rising Temperature Basic Select

  myoshi2891

  committed
  bb24e37

  Copy full SHA for bb24e37

Commits on Oct 8, 2025

• leetcode 182. Duplicate Emails Basic Select

  myoshi2891

  committed
  9f7cb88

  Copy full SHA for 9f7cb88

Commits on Oct 7, 2025

• leetcode 181. Employees Earning More Than Their Managers Basic Select

  myoshi2891

  committed
  909a676

  Copy full SHA for 909a676