-- From http://en.wikipedia.org/wiki/Sql

SELECT isbn, title, price, date 
FROM Book
WHERE price > 100.00
AND (date = '16042004' OR date = '16042005')
ORDER BY title;

START TRANSACTION;
  UPDATE Account SET amount=amount-200 WHERE account_number=1234;
  UPDATE Account SET amount=amount+200 WHERE account_number=2345;
IF ERRORS=0 COMMIT;
IF ERRORS<>0 ROLLBACK;