irregularexpressions questions

• SQL Join, include rows from table a with no match in table b
• complex SQL query to order by joined table data

irregularexpressions answers