engg.top

Customer Zones and Points

Easy

Description

For each customer, show customer_id, city, zone and points:

zone is North for Delhi, West for Mumbai, South for Bengaluru and Chennai, and Other for every other city
points is loyalty_points, but NULL when it is 0

End your query with ORDER BY customer_id.

Easy

For each customer, show customer_id, city, zone and points:

zone is North for Delhi, West for Mumbai, South for Bengaluru and Chennai, and Other for every other city
points is loyalty_points, but NULL when it is 0

End your query with ORDER BY customer_id.

Expected29 rows

customer_id	city	zone	points
1	Delhi	North	1200
2	Mumbai	West	850
3	Ahmedabad	Other	300
4	Patna	Other	NULL
5	Jaipur	Other	450
6	Lucknow	Other	670
7	Bengaluru	South	1500
8	Chennai	South	2100
9	Hyderabad	Other	250
10	Mumbai	West	3000
11	Pune	Other	900
12	Kochi	Other	150
13	Chennai	South	NULL
14	Delhi	North	520
15	Bengaluru	South	780
16	Delhi	North	1900
17	Pune	Other	640
18	Kolkata	Other	410
19	Hyderabad	Other	980
20	Varanasi	Other	260
21	Lucknow	Other	1120
22	Kochi	Other	330
23	Chennai	South	870
24	Bhopal	Other	100
25	Goa	Other	1350
26	Kolkata	Other	NULL
27	Surat	Other	NULL
28	Kochi	Other	50
29	Indore	Other	NULL

Output

Run query to see output