CREATE TABLE genre (g_name CLOB, rating CLOB, most_popular_in CLOB)
CREATE TABLE artist (artist_name CLOB, country CLOB, gender CLOB, preferred_genre CLOB)
CREATE TABLE song (song_name CLOB, artist_name CLOB, country CLOB, f_id NUMBER, genre_is CLOB, rating NUMBER, languages CLOB, releasedate TIME, resolution NUMBER)
CREATE TABLE files (f_id NUMBER, artist_name CLOB, file_size CLOB, duration CLOB, formats CLOB)

What are the top 3 artists with the largest number of songs in the language Bangla?
SELECT T1.artist_name FROM artist AS T1 JOIN song AS T2 ON T1.artist_name = T2.artist_name WHERE T2.languages = "bangla" GROUP BY T2.artist_name ORDER BY COUNT(*) DESC LIMIT 3
SELECT "T1"."artist_name" FROM "artist" "T1" JOIN "song" "T2" ON "T1"."artist_name" = "T2"."artist_name" AND "T2"."languages" = "bangla" GROUP BY "T2"."artist_name" ORDER BY COUNT(*) DESC FETCH FIRST 3 ROWS ONLY