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
Investigate this case →