How to make a selection from several tables in one select?

Question

SQL

Guys, please, send me an idea!
It is necessary to display the names of the artists and the genres in which they play, but on the condition that these artists perform their works in more than one genre. How can I check for a condition?
Tables:

CREATE TABLE "artist" (
    "id" INTEGER PRIMARY KEY AUTOINCREMENT,
    "name" TEXT
);
CREATE TABLE "style" (
    "id" INTEGER PRIMARY KEY AUTOINCREMENT,
    "name" TEXT
);
CREATE TABLE "artist_style" (
    "id" INTEGER PRIMARY KEY AUTOINCREMENT,
    "artist_id" INTEGER,
    "style_id" INTEGER,
    FOREIGN KEY ("artist_id") references artist("id"),
    FOREIGN KEY ("style_id") references style("id")
);

Answer 1

if I understood the task correctly, then this:
SELECT artist.id, artist.name, GROUP_CONCAT(style.name), count(artist_style.style_id) as cnt_style
FROM artist
LEFT JOIN artist_style ON artist_style.artist_id = artist.id
LEFT JOIN style ON artist_style .style_id = style.id
GROUP BY artist.id
HAVING cnt_style > 1