Question $4$

consider these two tables generated by a brand new music download app shown here along with their ERD. you will use these tables to answer questions three through seven. how many rows will there be in the result table of the correct query in question $3?$

c$)$ SELECT

u$.$username,

d$.$id download$\_$id$,$ d$.$file$\_$name

FROM users u

JOIN downloads d ON

u$.$id $=$ d$.$user$\_$id;

Question $4(14\mathrm{.}29$ points$)$

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

$\backslash$table$[[$id$,$username,premium$\_$user$],[1001,$ziggy,TRUE$],[1002,$aladdin,FALSE$],[1003,$duke,TRUE$],[1004,$tom,FALSE$],[1005,$jareth,FALSE$]]$

downloads table

$\backslash$table$[[$id$,$user$\_$id$,$file$\_$name$],[101,1002,$space$-$oddity$],[102,1004,$heroes$],[103,1002,$heroes$],[104,1005,$heroes$],[105,1001,$rebel$-$rebel$],[106,1002,$rebel$-$rebel$],[107,1005,$fame$],[108,1002,$changes$]]$

ERD

ERD