SELECT emp_no, dept_no, COUNT(from_date) AS no_of_contracts FROM dept_emp WHERE from_date>'2000-01-01' GROUP BY emp_no HAVING COUNT(from_date)>1 ORDER BY emp_no; The above query can also be used to get the actual number of contracts signed by the employees which are greater than 1. Is this correct?

Hi Archisman! Thanks for reaching out. Yes, this is correct! In this query, you are referring still to the same single table, which is dept_emp, therefore the aggregate function only contributes to obtaining a richer output. Thank you for sharing it with the Community! Kind regards,Martin

back

Follow this topic

Archisman Das

Last answered:

October 31, 2020

Posted on:

October 30, 2020

Resolved: Modification in Solution

1 answers ( 0 marked as helpful)

Martin Ganchev

Posted on:

October 31, 2020

Submit an answer

Content