Find the id of the order which is shipped most recently.
CREATE TABLE products (
    product_id number,
    product_name text,
    product_details text
)

CREATE TABLE shipments (
    shipment_id number,
    order_id number,
    invoice_number number,
    shipment_tracking_number text,
    shipment_date time,
    other_shipment_details text
)

CREATE TABLE orders (
    order_id number,
    customer_id number,
    order_status text,
    date_order_placed time,
    order_details text
)

CREATE TABLE invoices (
    invoice_number number,
    invoice_date time,
    invoice_details text
)

CREATE TABLE order_items (
    order_item_id number,
    product_id number,
    order_id number,
    order_item_status text,
    order_item_details text
)

CREATE TABLE shipment_items (
    shipment_id number,
    order_item_id number
)

CREATE TABLE customers (
    customer_id number,
    customer_name text,
    customer_details text
)
SELECT order_id FROM shipments WHERE shipment_date = (SELECT MAX(shipment_date) FROM shipments)
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: Find the id of the order which is shipped most recently. ### Input: CREATE TABLE products (
    product_id number,
    product_name text,
    product_details text
)

CREATE TABLE shipments (
    shipment_id number,
    order_id number,
    invoice_number number,
    shipment_tracking_number text,
    shipment_date time,
    other_shipment_details text
)

CREATE TABLE orders (
    order_id number,
    customer_id number,
    order_status text,
    date_order_placed time,
    order_details text
)

CREATE TABLE invoices (
    invoice_number number,
    invoice_date time,
    invoice_details text
)

CREATE TABLE order_items (
    order_item_id number,
    product_id number,
    order_id number,
    order_item_status text,
    order_item_details text
)

CREATE TABLE shipment_items (
    shipment_id number,
    order_item_id number
)

CREATE TABLE customers (
    customer_id number,
    customer_name text,
    customer_details text
) ### Response: SELECT order_id FROM shipments WHERE shipment_date = (SELECT MAX(shipment_date) FROM shipments)