I want to divide these below rows into 3 groups:
- Group 1 including Company A and Company B with very large amount
- Group 2 including Company C,D,E,F with medium amount
- Group 3 including Company G,H,I with very small amount
How can I do it using SQL? Thanks in advance!
| Company Name | Amount |
|---|---|
| Company A | 1,000,000 |
| Company B | 500,000 |
| Company C | 5,000 |
| Company D | 3,000 |
| Company E | 2,000 |
| Company F | 1,000 |
| Company G | 60 |
| Company H | 30 |
| Company I | 20 |
New contributor
Ma Hieu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.