Question $6$

Let us consider the following relational database.

Songs$($albumID$,$ artistID, songTitle, length, releasedYear$)$

The following SQL query is for retrieving the number of songs per album that was released in $2021.$

SELECT albumID, COUNT$()$ in the SELECT clause

b$.$ albumID in the SELECT clause

c$.$ The WHERE clause should be used instead of the HAVING clause for specifying a selection condition to pick the qualified records.

d$.$ albumID in the GROUP BY clause