For each file format, return the number of artists who released songs in that format.
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 genre (
    g_name varchar2(20),
    rating varchar2(10),
    most_popular_in varchar2(50)
)

CREATE TABLE artist (
    artist_name varchar2(50),
    country varchar2(20),
    gender varchar2(20),
    preferred_genre varchar2(50)
)
SELECT formats, COUNT(*) FROM files GROUP BY formats
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: For each file format, return the number of artists who released songs in that format. ### 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 genre (
    g_name varchar2(20),
    rating varchar2(10),
    most_popular_in varchar2(50)
)

CREATE TABLE artist (
    artist_name varchar2(50),
    country varchar2(20),
    gender varchar2(20),
    preferred_genre varchar2(50)
) ### Response: SELECT formats, COUNT(*) FROM files GROUP BY formats