search

microsoft / sql-server-samples

Azure Data SQL Samples - Official Microsoft GitHub Repository containing code samples for SQL Server, Azure SQL, Azure Synapse, and Azure SQL Edge
Other
9.97k stars 8.85k forks source link

Whats mean discount and how interpet #1309

Open JonnathanPerez opened 3 months ago

JonnathanPerez commented 3 months ago

Could you please help me in the interpretation of the discount table?

pubs-discount

Thanks in advance.

prashobthattari commented 2 months ago

My interpretation is:-

  1. Every new customer will get a discount of 10.50 (irrespective of store and quantity purchased)
  2. If a customer buys quantity between 100 and 1000, then they will get discount of 6.70 (irrespective of store)
  3. The store 8042 is giving a discount of 5.00 (irrespective of quantity)