Essential storage keeps sign-in and learning features working. Google Analytics measures visits; Microsoft Clarity records interactions to help us improve usability. Both are optional and stay off until you choose. Read our privacy policy.
Create an operations report that keeps every department—even departments with no courses—while counting its published courses and active enrollments. The joins must not inflate the course count, unpublished courses and cancelled enrollments must not contribute, and the final rows must be ordered by active demand.
Build Ada's receipt for order 1. Join customers, orders, order_lines, and products so each line shows display_name, order_id, sku, product name, qty, and line_cents (qty times unit_cents). Keep only order 1.
