How to correctly build a query from three tables?

Question

MySQL

There are three tables: Goods, Orders,
GoodsOrdersRelationshipItemsOrdersRelationship contains only IDs of Goods linked to Orders.
Products

• id
  
• Price
  

Orders

• id
  
• client id
  

CommunicationProductsOrders

• id
  
• product id
  
• order id
  
• quantity of such product with such id in the order
  

How to display orders so that there are such fields: total amount, quantity of all goods?

Answer 1

SELECT
 ol.order_id `Номер заказа`,
 c.name `Клиент`,
 count(ol.goods_id) `Всего позиций`,
 sum(ol.amount) `Кол-во товаров`,
 sum(g.cost) `Общая сумма`
FROM
 order_list ol,
 goods g,
 `order` o,
 client c
WHERE
 g.id=ol.goods_id
AND
 o.id=ol.order_id
AND
 c.id=o.client_id
GROUP BY ol.order_id;