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.
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
Yinka shey ole pe mi? O le ri num mi lori profile mi