Jump to content
Fórum Script Brasil
  • 0

[resolvido] Dúvida Consulta Sql


MicheL Vilela
 Share

Question

Olá pessoal, estou com uma dúvida para retornar uma consulta no SQL. Preciso retornar o nome do país que foi sede do maior número de competições (Ou seja, EUA nesse caso) usando a tabela abaixo. Como faço essa consulta? Obrigado pela ajuda!!

--------------------------------------------------------------------------------


tipo_comp                      pais_comp 
------------------------------ ------------------------------ 
COPA DO MUNDO                  ALEMANHA                      
PANAMERICANO                   ARGENTINA                      
OLIMPIADA                      AUSTRALIA                      
PANAMERICANO                   BRASIL                        
PANAMERICANO                   CANADA                        
OLIMPIADA                      COREIA                        
PANAMERICANO                   CUBA                          
OLIMPIADA                      ESPANHA                        
COPA DO MUNDO                  ESTADOS UNIDOS                
PANAMERICANO                   ESTADOS UNIDOS                
OLIMPIADA                      ESTADOS UNIDOS                
COPA DO MUNDO                  FRANÇA                        
OLIMPIADA                      GRECIA                        
COPA DO MUNDO                  ITALIA                        
COPA DO MUNDO                  JAPAO                          
PANAMERICANO                   REPUBLICA DOMINICANA

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

  • Forum Statistics

    • Total Topics
      149.8k
    • Total Posts
      646.6k
×
×
  • Create New...