Table T has column N, P, Q, F, FI
Where N, P, Q and F are attributes and FI is the price
We want to find out within each type of N, what is the price for each type of F.
Write a query.
SELECT N, F, FI FROM T
GROUP BY N, F
SELECT N, F, FI
FROM T
GROUP BY N, F
SELECT FI FROM T
GROUP BY N,F
SELECT N, F, max(FI)-- or min(FI)
FROM T
GROUP BY N, F