Select * from fooselect a,b from blahselect foo.blah from waah where a=bselect a as b from blahselect * from b where a.c is nullselect a as b from foo where a not null and (a = b or b = c) and (c = d or e = f)select a,b from c join d on c.foo = b.fooselect a-b as foo from bselect a,b from foo order by aselect distinct a from bselect a from b join (select a from b) on a = bselect a from b where c between d and eselect a from b join d on b.e = d.f as wibble where wibble.a = 5select * from foo where a not in (select * from b)select * from foo where lower(foo) = 5select * from b where b like '%a'insert into foo values (a,b)insert into foo (a,b) values (c,d)UPDATE films SET kind = 'Dramatic' WHERE kind = 'Drama'update foo set a=b, c=d  where foo=5