Posts by Natan Alonso • 11 points

• -3

  votes

  1

  answer

  57

  views

  Q: I need to present the product with the highest gross sales

  SELECT p.descricao_prod FROM produto p INNER JOIN venda v ON v.cod_prod = p.codigo WHERE p.preco = (SELECT MAX(p.preco) FROM produto p) I tried with this code, but, it only presents me the product…

  sql database postgresql

  asked 3 years, 2 months ago Natan Alonso 11