Fancy SQL Monday: generate_series() and cross joins

(Josh Berkus) So, here’s the situation: you want to create a report which shows totals of registrations by day and by category, and shows zeros for each day and category you don’t have any registrations for. Your first attempt looks like this:

Read More - Register for Free Membership