Task: **Retrieve Data With Aggregate Functions**

Console Missions
1

Mission: DATA MINER
Task: Retrieve Data With Aggregate Functions

Please, describe your problem here.
Hi there,

You you are doing great…

I’ve done this task correctly couple of times but the mission is not moving me forward!! can you please check and advise what’s wrong…

Many thnx
Yaser

2

Hi @Yaser_Bukhamseen ,

Could you show me step by step what you do to complete this mission so that I can help you, preferably with screenshots.

Regards,
Sergey

3

Hi dear Sergey,

Sure, I will record a Loom video and share it in a while.

Thanks
Yaser

4

Hi dear,

Here is a loom clip showing all the steps I did for this task.

Thanks
Yaser

5

Hi,

1. Data must be retrieved using REST API.

This means that you should not use the Rest Console to make the call, but you need to use a link outside the console as shown in the video.

Copy the link from the rest console and paste it into a new window in your browser to complete this mission, if the mission fails, double-check the signs and names with the link I attached below.

link

api/data/Country?props=COUNT(objectId)%20as%20CountryCount,Continent,MIN(LifeExpectancy)%20as%20MinLifeExpectancy,MAX(LifeExpectancy)%20as%20MaxLifeExpectancy&groupBy=Continent

Regards,
Sergey

6

Hi dear Sergey,

Yes this is exactly what i have done from the start just like what is shown in the video…
anyway,
let me do it again and get back to you.

Thanks
Yaser

7

Hi dear Sergey,

Alright, it worked and now moved into the next step,

Thanks dear
Yaser