#629

Rock Artists

A booker is planning a series of rock festivals and is shortlisting rock acts from the database. Output the name and country of every artist in the Rock genre, sorted by name.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.

countryartist_name
UKIron Sparrow
IrelandRiver Stones

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid