Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #288: Client's Rating Analysis

NISCHITHA-98
8 - Asteroid

Solution

jacekDziuba
7 - Meteor

my solution attached. Thanks for creating challenges!

 

 

rishabhkhandelwal
6 - Meteoroid

I did it in this way.

Toons
12 - Quasar

My solution :

 

Spoiler
Toons_0-1633425899505.png

 

Toons_1-1633425917845.pngToons_2-1633425932931.png

 

 

patrick_digan
17 - Castor
17 - Castor
Spoiler
patrick_digan_0-1633434842973.png

 

galmahalal
7 - Meteor

Here is my solution for the challenge.

 

Just one thing - it should be possible that there are requests without related customer in the customers table?
I think that the "right" part from the join should be blank - no requests without related customers. And if not, we should calculate the data from there also 🙂 

 

Thanks for that!

 

DaisukeTsuchiya
13 - Pulsar
Spoiler
キャプチャ.JPG

EDUAN_Swanepoel
5 - Atom

see attached my solution

chukleswk
11 - Bolide

Here is my solution:

 

Spoiler
Spoiler
Results.JPG

martin-krejci
6 - Meteoroid
Spoiler
martinkrejci_0-1633451782301.png