order by {field} sequence asc
order by {field} sequence desc
group by {field} sequence
having cond
<table1> left join <table2> on <table1>.field=<table2>.field
delete from <table>;
delete from <table> where cond;
group by <field> order by <field>;
group by <filed> having <cond>;