Craig S questions

• Is there a generic way to generate an arbitrary linear sequence in SQL?
• How can I use SQL to group and count the number of rows where the value for one column is <= x and the value for another column > x?
• JOIN on another table after GROUP BY and COUNT

Craig S answers