SELECT   pname, price, manufacturer

FROM     Product

WHERE   category=‘gizmo’ AND price > 50

ORDER BY  price, pname

Ordering is ascending, unless you specify the DESC keyword.

Ties are broken by the second attribute on the ORDER BY list, etc.