search

AlisdairO / pgexercises

PostgreSQL Exercises web site code
Other
400 stars 62 forks source link

add a 2013 booking #10

Closed dimidd closed 8 years ago

dimidd commented 9 years ago

In http://pgexercises.com/questions/aggregates/fachoursbymonth2.html: A query that doesn't check starttime is still considered correct, since there are no bookings after 2012. e.g.: select facid, extract(month from starttime) as month, sum(slots) from cd.bookings group by facid, month order by facid, month;

AlisdairO commented 9 years ago

Hey, thanks for the PR - I'll take a look and check that this modification doesn't impact any of the other exercises when I can. I may be a while, though - I have a three week old who is occupying a ot of my attention at the moment, so my apologies if it takes me some time to merge!

AlisdairO commented 8 years ago

Hey - I noticed this doesn't actually use a 2013 date, so I pushed my own fix. I realised as I pushed it I should have asked you to alter your PR - I'm very sorry!

dimidd commented 8 years ago

No problem, thanks for fixing :)

AlisdairO commented 8 years ago

Cheers :)