Quiz: Loading Database, REPL, Testing, and Indexing

Test your knowledge about loading databases, REPL, testing, and indexing.

1
  select genre.name, count(*) as count
    from           genre
         left join track using(genreid)
group by genre.name
order by count desc;

What does the given query return?

A)

The name and count of each genre in descending order of genre.name

B)

The name and count of each genre in the descending order of count

C)

The name and count of each track in descending order of count

D)

The name and count of each track in descending order of genre.name

Question 1 of 90 attempted

Get hands-on with 1400+ tech skills courses.