Practice Interview Questions
| Question | Status |
|---|---|
Identify companies whose revenue consistently increases every year without any dips. This means that if a company's revenue increases for several consecutive years but then experiences a dip in revenue, that company should not be included in the output.
company_revenue table:
| Column Name | Description |
|---|---|
| company | The name of the company |
| year | The fiscal year for the revenue data |
| revenue | The revenue of the company for that year |
| company |
|---|
| Microsoft |
Identify companies whose revenue consistently increases every year without any dips. This means that if a company's revenue increases for several consecutive years but then experiences a dip in revenue, that company should not be included in the output.
company_revenue table:
| Column Name | Description |
|---|---|
| company | The name of the company |
| year | The fiscal year for the revenue data |
| revenue | The revenue of the company for that year |
| company |
|---|
| Microsoft |