Routine~12min
The Tax-Free Vendors Who Aren't
34 invoices for standard taxable vendors were coded GST_EXEMPT and collected zero tax on ₹27.6L of revenue. The tax code was incorrectly copied from a test vendor during a bulk data import. One vendor really is exempt — don't flag them.
Tables you'll query
vendorsinvoices
What you'll learn
JOINsAggregations & GROUP BY