What are the names and location of the shops in ascending alphabetical order of name.
CREATE TABLE shop (
    shop_id number,
    shop_name text,
    location text,
    open_date text,
    open_year number
)

CREATE TABLE stock (
    shop_id number,
    device_id number,
    quantity number
)

CREATE TABLE device (
    device_id number,
    device text,
    carrier text,
    package_version text,
    applications text,
    software_platform text
)
SELECT shop_name, location FROM shop ORDER BY shop_name
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: What are the names and location of the shops in ascending alphabetical order of name. ### Input: CREATE TABLE shop (
    shop_id number,
    shop_name text,
    location text,
    open_date text,
    open_year number
)

CREATE TABLE stock (
    shop_id number,
    device_id number,
    quantity number
)

CREATE TABLE device (
    device_id number,
    device text,
    carrier text,
    package_version text,
    applications text,
    software_platform text
) ### Response: SELECT shop_name, location FROM shop ORDER BY shop_name