Search for a command to run...
Articles tagged with #coding-challenge
Problem Description & Analysis: There are two tables in a certain database. The original inventory table data_add stores multiple batches of inventory for multiple items. Each batch of inventory has a starting number START_NUM and an ending number EN...
Problem description & analysis: The field of a certain database table is strings. Task: Now we need to find the strings that contain at least 5 consecutive letters sorted alphabetically, or in other words, the longest substring in a continuous ascen...
Problem description & analysis: There are four strings separated into two parts by vertical bar, namely: ID|DUE_DATE, 80781|2026–12–01, VARCHAR2|DATE, |yyyy-mm-dd. Task: Now we need to generate a four-field result set, extract the first part of each ...
Problem description & analysis: A table stores events that occur for multiple accounts on multiple dates. Task: Now we need to find a pair of events that meet the criteria under each account, namely: event a with the earliest date, and event b with ...
Problem description & analysis: The table mytable in the MS SQL database has one ConfirmationStarted and multiple Closed statuses for each ID. Task: Now we need to find the record closest to ConfirmationStarted among all the Closed records before Co...
Problem description & analysis: The id and nbr of the MS SQL database table are grouping fields. After sorting the records within the group by time field dt, the order of 0 and 1 in the status field ‘status’ is different. Task: Now we need to genera...
