Databases have been the most important topic in every interview I've had: can you "select col, count (col) as count from tbl group by col?" Their omission on th

Databases have been the most important topic in every interview I've had: can you "select col, count (col) as count from tbl group by col?" Their omission on this list surprises me.