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