Resolved: SQL course exam question check
in the course exam case 1 question number 3, its about comparing the number of artists who have released albums to the total number of artists in a certain record table, you used a query that count(record_id) which is confusing since the same artist could release multiple albums under the same record_label, so we are double counting, am I right or wrong
should there be a group by for artists_id or how can we fix this
Hi Doaa!
Thanks for reaching out.
Thank you very much for pointing this out.
We will get back to you as soon as we double-check and verify the new solution.
In the meantime, the correct answer to this exam question doesn't change regardless of the caveat you are referring to.
Hope this helps.
Kind regards,
Martin
Hi Doaa!
Thank you very much for your patience.
We double-checked and apparently, our query is relevant to the current state of the 'albums' database. There is no need to use GROUP BY since we are only referring to a single record_label_id.
Hope this helps.
Kind regards,
Martin
Submit an answer
