Write a query to get the number of products that falls under each price bracket.

Price bracket can be created using the following criteria.

$($Hint: Price is higher than or equal to $10000$ then TIER $1$

Price between the $5500$ and $10000$ then TIER $2$

Price less than or equal to $5500$ then TIER $3)$

Select only one option

SELECT

PRICE$\_$BRACKET,

COUNT$($PRICE$\_$BRACKET$)$ AS COUNT$\_$OF$\_$PRODUCTS

FROM PRODUCT

WHERE PRICE$\_$BRACKET IN $($

SELECT PRODUCT$\_$ID$,$

PRODUCT$\_$PRICE,

CASE

WHEN PRODUCT$\_$PRICE $>=10000$ THEN 'TIER $1\text{'}$

WHEN PRODUCT$\_$PRICE BETWEEN $5500$ AND $10000$ THEN 'TIER $2\text{'}$

WHEN PRODUCT$\_$PRICE $<=5500$ THEN 'TIER $3\text{'}$

ELSE PRODUCT$\_$PRICE

END AS PRICE$\_$BRACKET

FROM PRODUCT

$)$ AS P

GROUP BY PRICE$\_$BRACKET;

SELECT

PRICE$\_$BRACKET,

COUNT$($PRICE$\_$BRACKET$)$ AS COUNT$\_$OF$\_$PRODUCTS

FROM $($

SELECT PRODUCT$\_$ID$,$

PRODUCT$\_$PRICE,

CASE

WHEN PRODUCT$\_$PRICE $>=10000$ THEN 'TIER $1\text{'}$

WHEN PRODUCT$\_$PRICE BETWEEN $5500$ AND $10000$ THEN 'TIER $2\text{'}$

WHEN PRODUCT$\_$PRICE $<=5500$ THEN 'TIER $3\text{'}$

ELSE PRODUCT$\_$PRICE

END AS PRICE$\_$BRACKET

FROM PRODUCT

$)$ AS P

GROUP BY PRICE$\_$BRACKET;

SELECT

PRICE$\_$BRACKET,

PRICE$\_$BRACKET

FROM $($

SELECT PRODUCT$\_$ID$,$

PRODUCT$\_$PRICE,

CASE

WHEN PRODUCT$\_$PRICE $>=10000$ THEN 'TIER $1\text{'}$

WHEN PRODUCT$\_$PRICE BETWEEN $5500$ AND $10000$ THEN 'TIER $2\text{'}$

WHEN PRODUCT$\_$PRICE $<=5500$ THEN 'TIER $3\text{'}$

ELSE PRODUCT$\_$PRICE

END AS PRICE$\_$BRACKET

FROM PRODUCT

$)$ AS P

GROUP BY PRICE$\_$BRACKET;