Loading problem...
A market intelligence system stores plain-text analyst notes in one table:
Table: Files
You must produce a two-row keyword coverage report for the words:
Coverage rule:
Implications of the rule:
Task: Return exactly two rows with columns:
Supported submission environments:
Files:
| file_name | content |
|-------------|-------------------------------------------------------------------------------------------------------|
| report1.txt | Weekly desk note says the market may enter a bull phase soon. |
| report2.txt | Strategy update says a bull setup exists now, but a bear scenario remains possible next quarter. |
| report3.txt | Risk memo says a bear setup is likely if rates stay elevated. |[
{"word":"bull","count":2},
{"word":"bear","count":2}
]Explanation
report1 and report2 contain ' bull '. report2 and report3 contain ' bear '.
Files:
| file_name | content |
|-------------|--------------------------------------------------------|
| a.txt | bullet points mention bears and bull. |
| b.txt | macro team expects a bear rebound over six weeks |
| c.txt | alpha bull beta bull gamma |[
{"word":"bull","count":1},
{"word":"bear","count":1}
]Explanation
a.txt has only false positives. b.txt contributes to bear once. c.txt contributes to bull once, even with repeated appearances.
Files:
| file_name | content |
|-----------|---------|[
{"word":"bull","count":0},
{"word":"bear","count":0}
]Explanation
With no files, both keyword counts are zero.
Constraints