1.连接order/customer/order_status三张表
    SELECT
    o.order_id,
    o.order_date,
    c.first_name,
    c.last_name
    os.name AS name
    FROM orders o
    JOIN customers c
    ON o.customer_id = c.customer_id
    JOIN order_status os
    ON o.status = os.order_status_id

    2.以client_id为主键连接payments表和client表数据，
    产生的新表以payment_method为键连接payment_methods表
    SELECT *
    FROM payments p
    JOIN clients c
    ON p.client_id = c.client_id
    JOIN payment_methods pm
    ON p.payment_method = pm.payment_method_id