Posts by marz • 26 points

• 1

  votes

  1

  answer

  66

  views

  A: Doubt select with Where in SQL Server!

  A possible solution: SELECT A.fabricante, A.modelo, count(distinct R.cgc) as NRevendedoras FROM Negocios AS N JOIN Revendedoras AS R on N.cgcRevenda = R.cgc JOIN Automoveis AS A on N.codAuto =…

  sql sql-server

  answered 4 years, 4 months ago marz 26