Search for a command to run...
Articles tagged with #reporting-tool
Problem description & analysis: The second and third fields of a certain database table are the starting year/month, and the ending year/month, respectively, in the format of “year M month”. Task: Now we need to add a calculated column TimePeriods: ...
Problem description & analysis: A certain database table records the execution status of a project, with multiple people participating in the project every day, and one person can participate in multiple tasks of the project in one day. Task: Now we...
Problem description & analysis: A certain table stores records of personnel from external sources entering and leaving a building by swiping their cards in recent days. When a person enters and exits a building, there are usually N pairs of records, ...
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: A certain table in the MS SQL database has a multi-level self-association structure, where the second field parent node ID is a foreign key pointing to the first field node ID of the table, and the third field is a zon...
Problem description & analysis: There is a transaction table for the asset accounts in the MS SQL database, with dates that are not consecutive. Task: Now we need to calculate the balance of each account for each month from January 2021 at the begin...
