Practical SQL exercises against the 6x rep_<ccid> databases
Before you start: This assessment has 5 SQL exercises against the 6x Reporting Server (rep_<ccid>).
You may open HawkDB Tool alongside this page and run queries against a test customer's reporting DB to validate your answers before submitting.
All timestamps in your output must be in Date/Time format — never epoch.
Step 1 · Verify your Google sign-in
This assessment requires you to be signed into your 3CLogic Google account (the same one you use for Gmail, Drive, and Docs).
Click the button below to verify — it opens a Google page in a new tab.
If you're already signed in: the new tab will briefly show a status page ("6x RS SQL Quiz endpoint is live") — you're good. Close it and continue below.
If you're not signed in: Google will prompt you. Sign in with your @3clogic.com account, close the tab, then continue.
If you see a Google Workspace error page: your browser has a personal Google account signed in, not your 3CLogic one. Add or switch to your 3CLogic account.