Thanks Old Pedant.. I appreciate your help here as well..
If i could as a couple of elementary questions (feel free not to answer as I'm certain they are very elementary)
SELECT L.lowest, E.*
FROM expedia AS E,
( SELECT tag, MIN(price) AS lowest
GROUP BY tag ) AS L
WHERE E.tag = L.tag
ORDER BY E.tag, E.price
what is the significance of 'L' and 'E'
basically.. what exactly is happening here..
with L.lowest, L, and E not being declared before.. i'm a bit confused.. where would this go?