topic Re: Challenge #339: Say Cheese Part 1 in Weekly Challenges

Challenge #339: Say Cheese (Part 1)

AYXAcademy — Thu, 18 May 2023 14:55:52 GMT

A solution to last week’s challenge can be found here.

Are you ready to explore a cheesy dataset?

This dataset provides information about the 2021 World Cheese Awards.

Your challenge is to:
- Find the category of cheese that has the highest average rating per category. Your answer must include the category number, the average rating, and the category name.
- Find all the companies that have a perfect rating of 4 in the category they entered. Your answer must include the company name, the average rating , and the count.

Hints:
You need to create a new rating system column based on the following:
SUPER GOLD = 4
GOLD = 3
SLIVER = 2
BRONZE = 1

In addition, create 2 new columns, category number and category name, using information from the category column.

Re: Challenge #339: Say Cheese Part 1

Mahmood — Thu, 18 May 2023 14:56:00 GMT

I guess I cheated a little bit using the join tool to find the companies with all 4 rating!

Re: Challenge #339: Say Cheese Part 1

Sebastian_Chaieb2 — Mon, 03 Oct 2022 13:35:25 GMT

My solution

Re: Challenge #339: Say Cheese Part 1

binu_acs — Mon, 03 Oct 2022 13:35:35 GMT

Re: Challenge #339: Say Cheese Part 1

MilindG — Mon, 03 Oct 2022 13:35:57 GMT

Re: Challenge #339: Say Cheese Part 1

AkimasaKajitani — Mon, 03 Oct 2022 13:48:54 GMT

My solution.

Re: Challenge #339: Say Cheese Part 1

RyanG45 — Mon, 03 Oct 2022 13:59:50 GMT

This was a puzzler - but a good challenge.

Re: Challenge #339: Say Cheese Part 1

balajilolla1 — Mon, 03 Oct 2022 14:06:49 GMT

Solution Attached

Re: Challenge #339: Say Cheese Part 1

ggruccio — Mon, 03 Oct 2022 14:35:00 GMT

Love using Expect Equal to check my work!

Re: Challenge #339: Say Cheese Part 1

RolandSchubert — Mon, 03 Oct 2022 14:40:24 GMT

Re: Challenge #339: Say Cheese Part 1

GabrielaTudor — Mon, 03 Oct 2022 14:48:27 GMT

Re: Challenge #339: Say Cheese Part 1

ahsanaali — Mon, 03 Oct 2022 15:44:28 GMT

Re: Challenge #339: Say Cheese Part 1

peterr_h — Mon, 03 Oct 2022 15:53:30 GMT

Possible solution :)

Didn't drop 'website' from company names, but could easily be achieved

Re: Challenge #339: Say Cheese Part 1

anni6shah — Mon, 03 Oct 2022 16:02:41 GMT

nice work!

Re: Challenge #339: Say Cheese Part 1

mmontgomery — Mon, 03 Oct 2022 16:02:50 GMT

Challenge 339. Used a switch to get values and deleted "Website" from company as the answer did that

Re: Challenge #339: Say Cheese Part 1

acarter881 — Mon, 03 Oct 2022 16:05:21 GMT

Here's my solution.

Re: Challenge #339: Say Cheese Part 1

Watermark — Mon, 03 Oct 2022 16:16:47 GMT

Re: Challenge #339: Say Cheese Part 1

Jean-Balteryx — Mon, 03 Oct 2022 16:28:39 GMT

Here is my workflow !

Re: Challenge #339: Say Cheese Part 1

akash327 — Mon, 03 Oct 2022 16:46:04 GMT

Solution

Re: Challenge #339: Say Cheese Part 1

patrick_digan — Mon, 03 Oct 2022 17:16:56 GMT