Every full 500 loyalty points earn one ₹100 voucher; leftover points don't count, so
1200 points earn 2 vouchers. Show every column of every customer, followed by the number of
vouchers they've earned as vouchers.
End your query with ORDER BY customer_id.
| customers |
|---|
| customer_id (PK) |
| full_name |
| phone |
| city |
| country |
| date_of_birth |
| loyalty_points |
| created_at |
Every full 500 loyalty points earn one ₹100 voucher; leftover points don't count, so
1200 points earn 2 vouchers. Show every column of every customer, followed by the number of
vouchers they've earned as vouchers.
End your query with ORDER BY customer_id.
| customers |
|---|
| customer_id (PK) |
| full_name |
| phone |
| city |
| country |
| date_of_birth |
| loyalty_points |
| created_at |
| customer_id | full_name | phone | city | country | date_of_birth | loyalty_points | created_at | vouchers | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Aisha Verma | aisha.verma@example.com | 9811000001 | Delhi | India | 1992-05-14T00:00:00.000Z | 1200 | 2023-06-04T00:00:00.000Z | 2 |
| 2 | Rahul Sharma | rahul.sharma@example.com | 9811000002 | Mumbai | India | 1988-11-02T00:00:00.000Z | 850 | 2023-06-07T00:00:00.000Z | 1 |
| 3 | Sneha Patel | sneha.patel@example.com | NULL | Ahmedabad | India | 1995-03-22T00:00:00.000Z | 300 | 2023-06-10T00:00:00.000Z | 0 |
| 4 | Amit Kumar | amit.kumar@example.com | 9811000004 | Patna | India | 1990-07-30T00:00:00.000Z | 0 | 2023-06-13T00:00:00.000Z | 0 |
| 5 | Pooja Singh | pooja.singh@example.com | 9811000005 | Jaipur | India | NULL | 450 | 2023-06-16T00:00:00.000Z | 0 |
| 6 | Vikash Yadav | vikash.yadav@example.com | 9811000006 | Lucknow | India | 1993-01-17T00:00:00.000Z | 670 | 2023-06-19T00:00:00.000Z | 1 |
| 7 | Neha Gupta | neha.gupta@example.com | 9811000007 | Bengaluru | India | 1997-09-09T00:00:00.000Z | 1500 | 2023-06-22T00:00:00.000Z | 3 |
| 8 | Rajesh Khanna | rajesh.khanna@example.com | 9811000008 | Chennai | India | 1985-12-25T00:00:00.000Z | 2100 | 2023-06-25T00:00:00.000Z | 4 |
| 9 | Kavita Rao | kavita.rao@example.com | NULL | Hyderabad | India | 1991-04-05T00:00:00.000Z | 250 | 2023-06-28T00:00:00.000Z | 0 |
| 10 | Sanjay Mehta | sanjay.mehta@example.com | 9811000010 | Mumbai | India | 1982-06-18T00:00:00.000Z | 3000 | 2023-07-01T00:00:00.000Z | 6 |
| 11 | Anita Desai | anita.desai@example.com | 9811000011 | Pune | India | 1994-08-11T00:00:00.000Z | 900 | 2023-07-04T00:00:00.000Z | 1 |
| 12 | Ravi Nair | ravi.nair@example.com | 9811000012 | Kochi | India | 1989-02-27T00:00:00.000Z | 150 | 2023-07-07T00:00:00.000Z | 0 |
| 13 | Meena Iyer | meena.iyer@example.com | 9811000013 | Chennai | India | NULL | 0 | 2023-07-10T00:00:00.000Z | 0 |
| 14 | Arun Joshi | arun.joshi@example.com | 9811000014 | Delhi | India | 1996-10-03T00:00:00.000Z | 520 | 2023-07-13T00:00:00.000Z | 1 |
| 15 | Divya Menon | divya.menon@example.com | 9811000015 | Bengaluru | India | 1993-05-19T00:00:00.000Z | 780 | 2023-07-16T00:00:00.000Z | 1 |
| 16 | Karan Malhotra | karan.malhotra@example.com | NULL | Delhi | India | 1987-03-08T00:00:00.000Z | 1900 | 2023-07-19T00:00:00.000Z | 3 |
| 17 | Pallavi Kulkarni | pallavi.kulkarni@example.com | 9811000017 | Pune | India | 1990-09-21T00:00:00.000Z | 640 | 2023-07-22T00:00:00.000Z | 1 |
| 18 | Nikhil Bose | nikhil.bose@example.com | 9811000018 | Kolkata | India | 1995-12-12T00:00:00.000Z | 410 | 2023-07-25T00:00:00.000Z | 0 |
| 19 | Shreya Reddy | shreya.reddy@example.com | 9811000019 | Hyderabad | India | 1998-07-07T00:00:00.000Z | 980 | 2023-07-28T00:00:00.000Z | 1 |
| 20 | Manoj Tiwari | manoj.tiwari2@example.com | 9811000020 | Varanasi | India | 1984-01-29T00:00:00.000Z | 260 | 2023-07-31T00:00:00.000Z | 0 |
| 21 | Fatima Khan | fatima.khan@example.com | 9811000021 | Lucknow | India | 1992-06-06T00:00:00.000Z | 1120 | 2023-08-03T00:00:00.000Z | 2 |
| 22 | George Thomas | george.thomas@example.com | 9811000022 | Kochi | India | 1986-04-16T00:00:00.000Z | 330 | 2023-08-06T00:00:00.000Z | 0 |
| 23 | Lakshmi Venkat | lakshmi.venkat@example.com | NULL | Chennai | India | 1991-11-23T00:00:00.000Z | 870 | 2023-08-09T00:00:00.000Z | 1 |
| 24 | Imran Sheikh | imran.sheikh@example.com | 9811000024 | Bhopal | India | NULL | 100 | 2023-08-12T00:00:00.000Z | 0 |
| 25 | Sara D'Souza | sara.dsouza@example.com | 9811000025 | Goa | India | 1997-02-14T00:00:00.000Z | 1350 | 2023-08-15T00:00:00.000Z | 2 |
| 26 | Rohan Das | rohan.das@example.com | 9811000026 | Kolkata | India | 1999-08-19T00:00:00.000Z | 0 | 2023-08-18T00:00:00.000Z | 0 |
| 27 | Priya Bhatt | priya.bhatt@example.com | NULL | Surat | India | 2000-03-04T00:00:00.000Z | 0 | 2023-08-21T00:00:00.000Z | 0 |
| 28 | Harish Pillai | harish.pillai@example.com | 9811000028 | Kochi | India | NULL | 50 | 2023-08-24T00:00:00.000Z | 0 |
| 29 | Zoya Ahmed | zoya.ahmed@example.com | 9811000029 | Indore | India | 1996-12-30T00:00:00.000Z | 0 | 2023-08-27T00:00:00.000Z | 0 |
Run query to see output