Adventureworks - Finding all the store names in the database

Question

so I'm learning SQL using the sample database Adventureworks and we've been given a couple of questions and with the correct number of rows so we will know if our queries are correct or not. I'm having trouble finding all the store names in the database.

Select name from Sales.Store;

Returns 701 rows but the correct answer is 1000 So my question is where can I find the other 299 store names. Is there another table I have to join?

What is the actual question? You need to write query based on the requirement. — Ullas, Nov 07 '15 at 08:46
The question is Find the names of all stores in the DB and the answer should be 1000 rows. — Jordan Daniel, Nov 07 '15 at 09:06
Where are you getting that the answer should be 1000? The count in my local copy is also 701. — Ben Thul, Nov 07 '15 at 14:16

score 1 · Answer 1 · answered Nov 07 '15 at 21:25

Your query is correct, the following two links both confirm that there are only 701 records in the [Sales].[Store] table. You should review the question or disregard the answer thats states it should be 1000.

https://www.innovasys.com/samples/dx/db/adventureworks_db~s-sales~t-store.html

http://elsasoft.com/samples/sqlserver_adventureworks/sqlserver.spring.katmai.adventureworks/table_SalesStore.htm

Adventureworks - Finding all the store names in the database

1 Answers1