Return first_name, salary and band: 'High' if salary is at least 1,00,000, otherwise 'Standard'.
20 rows with columns first_name, salary, band — first 3 shown:
| # | |||
|---|---|---|---|
| 1 | Anita | 250000 | High |
| 2 | Rahul | 180000 | High |
| 3 | Priya | 140000 | High |
Run your code to see the output here.