CIBC interview question

How will you extract a reapiting outcoume through SQL?