Query to get highest price and lowest price in database

[gizelle2101]

I've read the articles, but nothing is working. My database just lists jewelry by type and gems. I want to pull out the most expensive piece and the least expensive piece in one query.

<code>
mysql> SELECT type, gems, cost FROM inventory WHERE price=(SELECT MAX(cost) FROM inventory); </code>
This gets me the most expensive piece. When I try adding:
<code>
AND price=(SELECT MIN(cost) FROM inventory);</code>
I just get an error telling me my syntax is wrong.

Can someone help be put this into one query?

Thanks,
Gizelle

[ScarletPimpernal]

Try this query ....

SELECT type, gems, cost,MAX(price) ,MIN(price) FROM inventory GROUP BY germs.


Thanks,
Scarlet

[gizelle2101]

Try this query ....

SELECT type, gems, cost,MAX(price) ,MIN(price) FROM inventory GROUP BY germs.


Thanks,
Scarlet

Thank you this worked fine. You made it look so easy. Thanks again,
Gizelle