Practice Interview Questions
| Question | Status |
|---|---|
Identify the occurrences of 'bull' and 'bear' within the content, excluding variations like 'bullish' or 'bearish'. Display the word 'bull' and 'bear' alongside their respective occurrence counts.
The query should be case-insensitive, treating 'Bull', 'bull', 'Bear', and 'bear' as equivalent.
document_content table:
| Column Name | Description |
|---|---|
| filename | Name of the document file |
| contents | Text content of the document |
| word | occurrences |
|---|---|
| bear | 12 |
Identify the occurrences of 'bull' and 'bear' within the content, excluding variations like 'bullish' or 'bearish'. Display the word 'bull' and 'bear' alongside their respective occurrence counts.
The query should be case-insensitive, treating 'Bull', 'bull', 'Bear', and 'bear' as equivalent.
document_content table:
| Column Name | Description |
|---|---|
| filename | Name of the document file |
| contents | Text content of the document |
| word | occurrences |
|---|---|
| bear | 12 |
| bull | 9 |
| bull | 9 |