Posts by Mateus S. • 11 points

• 1

  votes

  1

  answer

  76

  views

  A: SQL queries of state names with their number of cities

  Good evening, Vinicius, sir. Ideally you would put the table scheme in question, but I believe it is a 'city' table with a 'state' field inside it. Try this: SELECT estado, COUNT(nome_cidade) AS…

  mysql sql database

  answered 4 years, 9 months ago Mateus S. 11