CODEWITHSUNDEEP
sql-servert-sql
delete
delete

Reputation:

If I have the following SQL database, how can I get this information?

Trying to learn TSQL once and for all :P

I'd like to select a list of Productos ordered by Category.

EDIT:

Here is the query I created with your help, but it's still not showing exactly what I'd like:

select p.Nombre as Nombre, c.Nombre as Categoria FROM Producto as p
inner join Subcategoria as s ON p.IDSubcategoria = s.ID
inner join Categoria as c on s.IDCategoria = c.ID
group by p.Nombre, c.Nombre
order by p.Nombre

Result:

alt text

So it would show:

Product Name, Product count, that has category X
Product Name, Product count, that has category X
Product Name, Product count, that has category X
Product Name, Product count, that has category X

Upvotes: 1

Views: 155

Answers (1)

Gideon
Gideon

Reputation: 18491

out the back of my head, and assuming that the number of records in Proveedor is the Count:

SELECT p.Nombre as Name, COUNT(pr.*), c.Nombre as Category FROM Producto as p
INNER JOIN Subcategoria as s ON p.IDSubcategoria = s.ID
INNER JOIN Categoria as c on s.IDCategoria = c.ID
INNER JOIN Proveedor as pr ON p.IDProveedor = pr.ID
GROUP BY p.Nombre, c.Nombre
ORDER BY p.Nombre

Please don't shoot me if it has a few errors.

Upvotes: 1

Related Questions