For the problem whose id is 10, bin the log_entry_date into the weekday interval and count the date, and return a bar chart, and I want to list by the Y-axis in ascending.
CREATE TABLE Product (
    product_id INTEGER,
    product_name VARCHAR(80),
    product_details VARCHAR(255)
)

CREATE TABLE Problem_Status_Codes (
    problem_status_code VARCHAR(20),
    problem_status_description VARCHAR(80)
)

CREATE TABLE Problem_Log (
    problem_log_id INTEGER,
    assigned_to_staff_id INTEGER,
    problem_id INTEGER,
    problem_category_code VARCHAR(20),
    problem_status_code VARCHAR(20),
    log_entry_date DATETIME,
    log_entry_description VARCHAR(255),
    log_entry_fix VARCHAR(255),
    other_log_details VARCHAR(255)
)

CREATE TABLE Problem_Category_Codes (
    problem_category_code VARCHAR(20),
    problem_category_description VARCHAR(80)
)

CREATE TABLE Staff (
    staff_id INTEGER,
    staff_first_name VARCHAR(80),
    staff_last_name VARCHAR(80),
    other_staff_details VARCHAR(255)
)

CREATE TABLE Problems (
    problem_id INTEGER,
    product_id INTEGER,
    closure_authorised_by_staff_id INTEGER,
    reported_by_staff_id INTEGER,
    date_problem_reported DATETIME,
    date_problem_closed DATETIME,
    problem_description VARCHAR(255),
    other_problem_details VARCHAR(255)
)
SELECT log_entry_date, COUNT(log_entry_date) FROM Problem_Log WHERE problem_id = 10 ORDER BY COUNT(log_entry_date)
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 the problem whose id is 10, bin the log_entry_date into the weekday interval and count the date, and return a bar chart, and I want to list by the Y-axis in ascending. ### Input: CREATE TABLE Product (
    product_id INTEGER,
    product_name VARCHAR(80),
    product_details VARCHAR(255)
)

CREATE TABLE Problem_Status_Codes (
    problem_status_code VARCHAR(20),
    problem_status_description VARCHAR(80)
)

CREATE TABLE Problem_Log (
    problem_log_id INTEGER,
    assigned_to_staff_id INTEGER,
    problem_id INTEGER,
    problem_category_code VARCHAR(20),
    problem_status_code VARCHAR(20),
    log_entry_date DATETIME,
    log_entry_description VARCHAR(255),
    log_entry_fix VARCHAR(255),
    other_log_details VARCHAR(255)
)

CREATE TABLE Problem_Category_Codes (
    problem_category_code VARCHAR(20),
    problem_category_description VARCHAR(80)
)

CREATE TABLE Staff (
    staff_id INTEGER,
    staff_first_name VARCHAR(80),
    staff_last_name VARCHAR(80),
    other_staff_details VARCHAR(255)
)

CREATE TABLE Problems (
    problem_id INTEGER,
    product_id INTEGER,
    closure_authorised_by_staff_id INTEGER,
    reported_by_staff_id INTEGER,
    date_problem_reported DATETIME,
    date_problem_closed DATETIME,
    problem_description VARCHAR(255),
    other_problem_details VARCHAR(255)
) ### Response: SELECT log_entry_date, COUNT(log_entry_date) FROM Problem_Log WHERE problem_id = 10 ORDER BY COUNT(log_entry_date)