Questions
Status
Sliding window rangeMediumWrite codeAmazon styleWrite codeAmazon styleMedium25 minTop category per customerMediumWrite codeWrite codeMedium25 minInner equi-joinMediumWrite codeSnowflake styleWrite codeSnowflake styleMedium30 minFlatten nested dictMediumWrite codeStripe styleWrite codeStripe styleMedium30 minPattern matching with mismatchesMediumWrite codeWrite codeMedium25 minBoolean expression evaluatorMediumWrite codeWrite codeMedium30 minTernary expression evaluatorMediumWrite codeWrite codeMedium25 minFunction exclusive timeMediumWrite codeMeta styleWrite codeMeta styleMedium30 minRelational inner joinMediumWrite codeSnowflake styleWrite codeSnowflake styleMedium25 minSpike detection anomaliesMediumWrite codeDatabricks styleWrite codeDatabricks styleMedium25 minPivot long-format recordsMediumWrite codeSnowflake styleWrite codeSnowflake styleMedium30 mink-nearest-neighbors classificationMediumWrite codeMeta styleWrite codeMeta styleMedium25 mink-means assignmentMediumWrite codeMeta styleWrite codeMeta styleMedium22 minNumerically stable softmaxMediumWrite codeOpenAI styleWrite codeOpenAI styleMedium18 minZ-score standardizationMediumWrite codeWrite codeMedium18 minGini impurityMediumWrite codeMeta styleWrite codeMeta styleMedium18 minShannon entropyMediumWrite codeMeta styleWrite codeMeta styleMedium18 minBinary classification metricsMediumWrite codeMeta styleWrite codeMeta styleMedium22 minConfusion matrixMediumWrite codeMeta styleWrite codeMeta styleMedium20 minCollapse request status logMediumWrite codeWrite codeMedium14 minVersion range queriesMediumWrite codeWrite codeMedium25 minCache key normalizationMediumWrite codeWrite codeMedium25 minSmallest rotation of belt readingsMediumWrite codeWrite codeMedium25 minCanonical routing tableMediumWrite codeCisco styleWrite codeCisco styleMedium25 minDecompose rate matrixMediumWrite codeWrite codeMedium20 minFind duplicate rowsMediumWrite codeDatabricks styleWrite codeDatabricks styleMedium25 minOrders from a set of customersMediumData framesData framesMedium7 minCheapest product in each categoryMediumData framesData framesMedium9 minSecond highest distinct salaryMediumData framesData framesMedium8 minPaid revenue per customerMediumData framesData framesMedium9 minPay range per teamMediumData framesData framesMedium10 minTeams with more than one personMediumData framesData framesMedium9 minEach team share of payrollMediumData framesData framesMedium10 minKeep employees whose team has no budgetMediumData framesData framesMedium9 minBudgets nobody is spendingMediumData framesData framesMedium10 minEveryone earning more than their managerMediumData framesData framesMedium11 minJoin on differently named keysMediumData framesData framesMedium9 minOne row per student, one column per subjectMediumData framesData framesMedium10 minUnpivot subject columns back to rowsMediumData framesData framesMedium10 minCount of orders by customer and statusMediumData framesData framesMedium10 minHow many gaps in each columnMediumData framesData framesMedium9 minKeep the newest record per emailMediumData framesData framesMedium9 minFind the addresses at one domainMediumData framesData framesMedium9 minOrders placed in one monthMediumData framesData framesMedium10 minRevenue by calendar monthMediumData framesData framesMedium11 minRank pay within each teamMediumData framesData framesMedium11 minRunning total of order valueMediumData framesData framesMedium11 minFill a gap with that device own averageMediumData framesData framesMedium11 minSplit a sku into its partsMediumData framesData framesMedium10 minSort by team, then pay descendingMediumData framesData framesMedium8 min