Asynchronous Cohort Test

How do you feel about Joins And Aggregare Functions?

1 = I do not know what Joins OR Aggregate Functions are.

5 = I feel confident, I just want to test myself.

• 1

• 2

• 3

• 4

• 5

Please share your name and studentID

If I am taking this for a retake, I understand that:

I will have to take a coding quiz at the end of this cohort and send my results to my CI.

Please type OK in the box below.

How many tables do we have in our database?

Please click the link below

https://onecompiler.com/challenges/42xp74kty/cohort-3-joins-aggregate-functions

Type in READY once you have it open.

Answer explanation

Missed the link?

https://onecompiler.com/challenges/42xp74kty/cohort-3-joins-aggregate-functions

Let's Take some time to create our account.

Once, you are done, type READY below

What do we use to sort tables by columns in MySQL?

• GROUP BY

• FILTER BY

• ORDER BY

• SORT BY

What do we use in MySQL when we want to filter rows based on certain conditions?

• CHECK

• WHERE

• FILTER BY

• HAVING

How do we feel about these warmups?

• 
• 
• 
• 
• 

Give an example of aggregate function