For each customer, show customer_id, full_name, phone (the text Not provided
when the phone is missing) and tier:
gold with 3000 or more loyalty pointssilver with 1200 or morebronze otherwiseEnd your query with ORDER BY customer_id.
| customers |
|---|
| customer_id (PK) |
| full_name |
| phone |
| loyalty_points |
For each customer, show customer_id, full_name, phone (the text Not provided
when the phone is missing) and tier:
gold with 3000 or more loyalty pointssilver with 1200 or morebronze otherwiseEnd your query with ORDER BY customer_id.
| customers |
|---|
| customer_id (PK) |
| full_name |
| phone |
| loyalty_points |
| customer_id | full_name | phone | tier |
|---|---|---|---|
| 1 | Aisha Verma | 9811000001 | silver |
| 2 | Rahul Sharma | 9811000002 | bronze |
| 3 | Sneha Patel | Not provided | bronze |
| 4 | Amit Kumar | 9811000004 | bronze |
| 5 | Pooja Singh | 9811000005 | bronze |
| 6 | Vikash Yadav | 9811000006 | bronze |
| 7 | Neha Gupta | 9811000007 | silver |
| 8 | Rajesh Khanna | 9811000008 | silver |
| 9 | Kavita Rao | Not provided | bronze |
| 10 | Sanjay Mehta | 9811000010 | gold |
| 11 | Anita Desai | 9811000011 | bronze |
| 12 | Ravi Nair | 9811000012 | bronze |
| 13 | Meena Iyer | 9811000013 | bronze |
| 14 | Arun Joshi | 9811000014 | bronze |
| 15 | Divya Menon | 9811000015 | bronze |
| 16 | Karan Malhotra | Not provided | silver |
| 17 | Pallavi Kulkarni | 9811000017 | bronze |
| 18 | Nikhil Bose | 9811000018 | bronze |
| 19 | Shreya Reddy | 9811000019 | bronze |
| 20 | Manoj Tiwari | 9811000020 | bronze |
| 21 | Fatima Khan | 9811000021 | bronze |
| 22 | George Thomas | 9811000022 | bronze |
| 23 | Lakshmi Venkat | Not provided | bronze |
| 24 | Imran Sheikh | 9811000024 | bronze |
| 25 | Sara D'Souza | 9811000025 | silver |
| 26 | Rohan Das | 9811000026 | bronze |
| 27 | Priya Bhatt | Not provided | bronze |
| 28 | Harish Pillai | 9811000028 | bronze |
| 29 | Zoya Ahmed | 9811000029 | bronze |
Run query to see output