stores orders

stores_orders.sql

select orders.id as 'номер заказа',
       orders.total as `сумма всего заказа`,
       s.name as 'магазин покупки',
       c.user_name as 'имя покупателя',
       p.name as 'товар',
       o.qt as 'кол-во'

    from orders
    join orders_details o on orders.id = o.order_id
    join stores s on s.id = o.store_id
    join customers  c on c.id = orders.user_id
    join products p on p.id = o.product_id

where o.store_id = 1;