Rock Artists

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. Your answer must use the same column names as this sample — alias them with AS if needed.

artist_namecountry
Iron SparrowUK
River StonesIreland

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid