Q1 : Which brand has the most products that cost less than 40 EUR?

A1 :

As we have been asked to find the brand that has the most products that cost less than 40 EUR, I have done the following steps:

• Filtering the products that cost less than 40 EUR.
• Counting the number of these products for each brand.
• Determining which brand has the highest count.

Q2 : Which brand hoffers the largest selection of sizes to the customer?

A2 :

Calculating the unique sizes was the most important part of this question. I have done the following steps:

• Counting the number of unique sizes per brand.
• Determining which brand has the largest number of unique sizes.

Q3 : Which brand brand offers the lowest average price for customers wearing size “32”?

A3 :

Size “32” is the key point of this question. I have done the following steps:

• Filtering products that are available in size “32” .
• Calculating the average price for these products for each brand.
• Finding the brand with the lowest average price.