I have a problem where I need to create new entries in the SpecialOfferProduct table. I am applying my created discount (SpecialOfferID = 20) to all products that have an inventory greater than 1800 but I can’t figure out what I am doing wrong. this is my code. It’s from the AdventureWorks2012 database Thanks Answer did you means it
Tag: adventureworks
Adventure Works 2014 SQL Queries
I am writing a SQL query using Adventure Works 2014 database. I want to show all customers and how many orders each customers have. I tried to write each select statement by itself (see below), but I’d like to be able to combine both queries into one. Answer
Does AdventureWorks db have tutorials / exercises? [closed]
I downloaded and installed AdventureWorks db for sql server 2008. Are there any exercises or tutorials for it? I’d like to to practice SQL select statements