Consider these two tables generated by a brand$-$new music downloading app, shown here along with their ERD. You will use these tables to answer questions $3$ through $7.$

users table

id username premium$\_$user

$1001$ ziggy TRUE

$1002$ aladdin FALSE

$1003$ duke TRUE

$1004$ tom FALSE

$1005$ jareth FALSE

downloads table

id user$\_$id file$\_$name

$1011002$ space$-$oddity

$1021004$ heroes

$1031002$ heroes

$1041005$ heroes

$1051001$ rebel$-$rebel

$1061002$ rebel$-$rebel

$1071005$ fame

$1081002$ changes

ERD

An entity relationship diagram showing the connection between two tables: A user table, and a downloads table. The users table contains three fields: id$,$ username, and premium user. The id field is the primary key of the users table. The downloads table contains three fields: id$,$ user$\_$id$,$ and file$\_$name. Within the downloads table, the id field is the primary key, and user$\_$id is a foreign key with a many to one relationship to the primary key in the users table.

Now, consider a third table called songs that lists all songs in this music service's collection.

downloads table

id user$\_$id file$\_$name

$1011002$ space$-$oddity

$1021004$ heroes

$1031002$ heroes

$1041005$ heroes

$1051001$ rebel$-$rebel

$1061002$ rebel$-$rebel

$1071005$ fame

$1081002$ changes

songs table

file$\_$name year$\_$released

changes $1971$

fame $1975$

heroes $1977$

modern$-$love $1983$

rebel$-$rebel $1974$

space$-$oddity $1969$

starman $1972$

New ERD, including songs table

An entity relationship diagram showing the connection between three tables: Users, downloads, and songs. The users table contains three fields: id$,$ username, and premium$-$user. The id field is the primary key of the users table. The downloads table contains three fields: id$,$ user$\_$id$,$ and file$\_$name. The id field is the primary key of the downloads table. User$\_$id is a foreign key that has a many to one relationship with the user table$$s primary key. File$\_$name is a foreign key that has a many to one relationship with the songs table$$s primary key. The songs table contains two fields: file$\_$name, and year$\_$released. The file$\_$name field is the primary key of the songs table.

If you were to use the query below to RIGHT JOIN the downloads table to the songs table, how many rows would be in the resulting table?

SELECT

d$.$id$,$

d$.$file$\_$name,

s$.$year$\_$released

FROM downloads d

RIGHT JOIN songs s

ON d$.$file$\_$name $=$ s$.$file$\_$name;

Question $7$ options:

a$)$

$5$

b$)$

$7$

c$)$

$8$

d$)$

$10$