Show the shortest duration and lowest rating of songs grouped by genre using a bar chart, I want to show by the Y in asc.
CREATE TABLE files (
    f_id number(10),
    artist_name varchar2(50),
    file_size varchar2(20),
    duration varchar2(20),
    formats varchar2(20)
)

CREATE TABLE song (
    song_name varchar2(50),
    artist_name varchar2(50),
    country varchar2(20),
    f_id number(10),
    genre_is varchar2(20),
    rating number(10),
    languages varchar2(20),
    releasedate Date,
    resolution number(10)
)

CREATE TABLE artist (
    artist_name varchar2(50),
    country varchar2(20),
    gender varchar2(20),
    preferred_genre varchar2(50)
)

CREATE TABLE genre (
    g_name varchar2(20),
    rating varchar2(10),
    most_popular_in varchar2(50)
)
SELECT MIN(T1.duration), MIN(T2.rating) FROM files AS T1 JOIN song AS T2 ON T1.f_id = T2.f_id GROUP BY MIN(T1.duration) ORDER BY MIN(T2.rating)
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Show the shortest duration and lowest rating of songs grouped by genre using a bar chart, I want to show by the Y in asc. ### Input: CREATE TABLE files (
    f_id number(10),
    artist_name varchar2(50),
    file_size varchar2(20),
    duration varchar2(20),
    formats varchar2(20)
)

CREATE TABLE song (
    song_name varchar2(50),
    artist_name varchar2(50),
    country varchar2(20),
    f_id number(10),
    genre_is varchar2(20),
    rating number(10),
    languages varchar2(20),
    releasedate Date,
    resolution number(10)
)

CREATE TABLE artist (
    artist_name varchar2(50),
    country varchar2(20),
    gender varchar2(20),
    preferred_genre varchar2(50)
)

CREATE TABLE genre (
    g_name varchar2(20),
    rating varchar2(10),
    most_popular_in varchar2(50)
) ### Response: SELECT MIN(T1.duration), MIN(T2.rating) FROM files AS T1 JOIN song AS T2 ON T1.f_id = T2.f_id GROUP BY MIN(T1.duration) ORDER BY MIN(T2.rating)