logo

Back to questions

QuickBooks vs TurboTax

Easy

Intuit offers several tax filing products, such as TurboTax and QuickBooks, which come in multiple versions.

Write a query to find the total number of filings that used TurboTax, and the total number of filings that used QuickBooks.

Assumption:

  • As reflected in the table, a user can only file taxes once a year using one product.

Table:

Column NameType
filing_idinteger
user_idvarchar
filing_datedatetime
productvarchar

Example Input:

filing_iduser_idfiling_dateproduct
114/14/2019TurboTax Desktop 2019
214/15/2020TurboTax Deluxe
314/15/2021TurboTax Online
424/07/2020TurboTax Online
524/10/2021TurboTax Online
634/07/2020TurboTax Online
734/15/2021TurboTax Online
833/11/2022QuickBooks Desktop Pro
944/15/2022QuickBooks Online

Example Output:

turbotax_totalquickbooks_total
72

Explanation

There were 7 filings using TurboTax and 2 filings using QuickBooks.

If you like this question, try out a similar question, Laptop vs Mobile Viewers!

PostgreSQL 14

Refer friends to get bonus content & cool prizes.