Posted on:

29 Mar 2022

0

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

0 answers ( 0 marked as helpful)

Submit an answer