Last answered:

13 Aug 2022

Posted on:

16 Jul 2022

1

Resolved: Using aggregate function on more than one table

We have so far taking a couple of aggregate functions on one table at a time, what if we want to use the function on more than one table? Let's say we want to know the minimum salary (from the salaries table) of a particular department (from the dept_emp table except if classes that teach this is still ahead.

2 answers ( 1 marked as helpful)
Posted on:

20 Jul 2022

1

Hi Yinka!

Thanks for reaching out.

Your question is great, and so is your intuition, in the sense that A) yes, SQL (and in particular, MySQL) does allow referring to several tables at a time when using aggregate functions (and not only), and B) we do teach this later in the course. The lectures in question are covered in the SQL JOINs topic, starting here: https://learn.365datascience.com/courses/sql/introduction-to-joins/

Hope this helps but please feel free to get back to us should you need further assistance. Thank you.
Best,
Martin

Posted on:

13 Aug 2022

0

Yinka shey ole pe mi? O le ri num mi lori profile mi

Submit an answer