Help to write a query, which from the top table will output the bottom like it works but not completely

SELECT count (Object) from Table1 where Customer = 'MTZ'

enter image description here

Closed due to the fact that the question is too general for the participants cheops , VenZell , zRrr , aleksandr barakin , user194374 12 Jun '16 at 6:02 .

Please correct the question so that it describes the specific problem with sufficient detail to determine the appropriate answer. Do not ask a few questions at once. See “How to ask a good question?” For clarification. If the question can be reformulated according to the rules set out in the certificate , edit it .

  • And "not completely" - is it like? It seems to have to choose exactly what is drawn exactly as it is written - Mike
  • you only need to choose MTZ - Vlad
  • that's what you do - Mike

1 answer 1

SELECT заказчик, count(*) кол_во from Таблица1 group by заказчик having count(*) > 1