Task: Text to Code
Input (English): Step 1: For each row in genre table, find the corresponding rows in song table.
Step 2: find f_id, g_name, artist_name of the results of step 1 ordered ascending by song's rating
Output (English): SELECT T2.f_id , T1.g_name , T2.artist_name FROM genre AS T1 JOIN song AS T2 ON T1.g_name = T2.genre_is ORDER BY T2.rating Asc