Posts by Rey11 • 25 points

• 1

  votes

  1

  answer

  98

  views

  Q: Consult the names of the pilots sponsored by a Team

  I want to consult pilots sponsored by the 'A' team' I’m doing like this: SELECT piloto.nome AS NomePiloto FROM equipe INNER JOIN piloto ON equipe.idequipe = piloto.idequipe INNER JOIN patrocinador…

  sql database postgresql

  asked 6 years ago Rey11 25

• 1

  votes

  1

  answer

  1282

  views

  Q: See the best-selling product

  I’m having trouble joining two tables and using some aggregation function, I’ve tried it like this: SELECT nome FROM produto INNER JOIN vendaproduto SUM(quantidade) ON produto.idproduto =…

  sql database postgresql

  asked 6 years, 3 months ago Rey11 25