You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
select sum(case when product like 'Turbo%' then 1 else 0 end) as turbotax_total,sum(case when product like 'QuickB%' then 1 else 0 end) as quickbooks_total
from filed_taxes
--------
Intuit provides a range of tax filing products, including TurboTax and QuickBooks, available in various versions.
Write a query to determine the total number of tax filings made using TurboTax and QuickBooks. Each user can file taxes once a year using only one product.
If you find this question interesting, you may also want to try a similar question called Laptop vs Mobile Viewers!