Dear friends, there is such a table in mysql enter image description here

What request to make to summarize the number of firms by city, regardless of the column industry. For example, to be so enter image description here

Is it right to do so?

SELECT Название_города,SUM(кол-во_фирм) FROM mysql_table GROUP BY Название города; 
  • four
    Yes, right. Ps. Sometimes it is faster to try than to ask and wait for an answer ... - Akina

0