Write the SQL to label and count the number of customers that meet the following conditions: a. Purchased fewer than 20 units of 'automotive' products lifetime AND spent less than $800 lifetime of product type 'kitchen', label them 'Blue'
b. Purchased between 20 and 30 units of 'automotive' products lifetime AND spent less than $800 lifetime of product type 'kitchen', label them 'Green'
c. Purchased between 31 and 45 units of 'automotive' products lifetime AND spent less than $800 lifetime of product type 'kitchen', label them 'Orange'
d. Purchased between 46 and 60 units of 'automotive' products lifetime AND spent BETWEEN $801 and $3000 lifetime of product type 'kitchen', label them 'Purple'
e. Else 'Unknown'