A company wants to designate iss customers into one of the followng $4$ categories:

GOLD, PLATINUM, SILVER, and REGULAR. The customers designated to each of this categories receive different perks and promotions.

To determine the customer category, the criteria below is used. IF:

Total purchases $100,000,$ designate the customer as "GOLD"

Total purchases $50,000,$ designate the customer as "PLATINUM"

Total purchases $25,000,$ designate the customer as "SILVER"

For all other customers, designate the customer as "Regular"

$\backslash$table$[[$OrderID$,$CustomerID,Customer City,$\backslash$table$[[$Customer$],[$State$]],,\backslash$table$[[$otal$],[$chases$]],\backslash$table$[[$Years as$],[$Customer$]],$Customer Category$],[1709,6121,$Buffalo,NY$,$$$,157,000,2\mathrm{.}07,],[1671,6007,$Little Rock,AR$,$$$,100,572,5\mathrm{.}62,],[463,2383,$Little Rock,AR$,$$$,9,000,0\mathrm{.}14,],[464,2386,$Little Rock,AR$,$$$,9,000,0\mathrm{.}14,],[465,2389,$Atlanta,GA$,$$$,14,000,0\mathrm{.}14,],[466,2392,$Atlanta,GA$,$$$,24,000,0\mathrm{.}14,],[467,2395,$New York,NY$,$$$,9,000,0\mathrm{.}14,],[468,2398,$New York,NY$,$$$,14,000,0\mathrm{.}14,],[469,2401,$New York,NY$,$$$,9,000,0\mathrm{.}14,],[820,3454,$Little Rock,AR$,$$$,9,000,0\mathrm{.}56,]]$