w3resource

AdventureWorks Database: Tax difference between highest and lowest-taxed state or province

SQL Query - AdventureWorks: Exercise-139 with Solution

139. From the following table write a query in SQL to calculate the tax difference between the highest and lowest tax-rate state or province.

Sample table: Sales.SalesTaxRate


Click to view Full table

Sample Solution:

SELECT MAX(TaxRate) - MIN(TaxRate) AS "Tax Rate Difference"  
FROM Sales.SalesTaxRate  
WHERE StateProvinceID IS NOT NULL;

Sample Output:

Tax Rate Difference|
-------------------+
               14.6|

SQL AdventureWorks Editor:

Practice Online


Contribute your code and comments through Disqus.

Previous: Add vacation and sick time to find total hours away from work.
Next: Calculate sales targets per month for salespeople.


What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Follow us on Facebook and Twitter for latest update.