P
P
Philip Shishkin2020-11-13 11:56:59
SQL
Philip Shishkin, 2020-11-13 11:56:59

What is the command to display the city with the largest number of animals?

there is a table

CREATE TABLE Zoo
;
INSERT INTO Zoo
  (`id`, `city`, `animals_id`)
VALUES
  (1, 'Novosibirsk', '1'),
  (2, 'Moscow', '2'),
  (3, 'Novosibirsk', '3'),
        (4, 'Novosibirsk', '4'),
        (5, 'Tomsk',   '5')
;


What team can do this?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question