Table: cape_epic_results
Columns: date
category
team
rider_1
rider_2

Question: Which category earlier than 2006 has Bart Brentjens as rider 2?
SQL: SELECT "category" FROM cape_epic_results WHERE "date" < 2006 AND "rider_2" = 'bart brentjens'

Question: How many dates does the ladies category correspond to Rothaus-Cube?
SQL: SELECT COUNT("date") FROM cape_epic_results WHERE "category" = 'ladies' AND "team" = 'rothaus-cube'

Question: Which category has a team of Cannondale Vredestein?
SQL: SELECT "category" FROM cape_epic_results WHERE "team" = 'cannondale vredestein'