!all tables

Better try asking for something more specific;Helpful hint

!AskAnything

{Ask about anything related to Northwind;More info about asking questions};{database map;Follow link}

LINK TO COME

!brainiac

What is ELF? A very smart computer program;Handles off-topic queries too

!ContactPoint

elfsoft@aol.com;Contact email

!fuck

Now now;Please use civil language

!hello

Hello, welcome to Northwind Specialty Foods database;Greetings from our staff

!InfoJuke

Try using www.infojukebox.com;Best search engine on the Web

!IsNotBooks

This database is not for a bookstore, it's for a specialty food store;Concentrate, please

!language

You may be looking for our natural language search engine, InfoJukebox!;Here's a tip.

!LifeMeaning

When you purchase our products you also receive, free, the meaning of life;Special offer

!New York

Sorry, don't have NY in the database

!NOTASTATE

Sorry, don't have it in the database

!salary

Salary information is not made public

!send

Sorry, not in order placement mode;Data access only, please

!sex

Sex? Yes please.; More info required

!ShowHelp

Help is available here;Thanks for asking

link to come

!SYSTABLES

You don't really want to snoop on our System Tables, do you?;Word to the wise

!TableList

Categories,Employees,Order Details,Orders,Products,Suppliers,Shippers;Northwind Tables

!test question

Test question? OK, test answer;Pretty easy to customize

!This is a test

No, this is a computer.;Repeat after me

[^hi^]

hello {1}

A

[^list the tables^]

TableList

[{NoLocations_}]

NOTASTATE

[{ProductName} by region]

{1} by customers_ . region

[{ProductName} by state]

{1} by customers_ . region

[{ProductName} sales]

ExtendedPrice for {1}

[< {#} {QuantityPerUnit}]

less than {#} {1}

[<= {#} {QuantityPerUnit}]

at most {#} {1}

[> {#} {QuantityPerUnit}]

more than {#} {1}

[>= {#} {QuantityPerUnit}]

at least {#} {1}

[age]

Int(DateDiff('d',[Employees].[BirthDate],Now())/365.25)

Function

[all {CATEGORY}]

all {1} products

[clearance]

Security_Clearance(Employees.LastName,Employees.HireDate)

Function

[customers first and last names]

customers contactname

[date we hired]

hiredate of

[element]

acorn

acorn has no meaning

[employees live in {REGION}]

employees_ . region='{1}'

[European]

Italy or France or Spain or Germany

[hi ]

highest {1}

[highest sale]

highest extended price

[how big was]

show

[how can I contact]

phone, contactname

[how do I contact ELF]

ContactPoint

[how do i find info about]

InfoJuke

[how do you work]

ShowHelp

[How does this work]

ShowHelp

[how many {Category}]

[how many {1} | how many {1} products] * how many products

how many beverages

[how many {ProductName}]

[how many {1} | total quantity of {1} products that] > supplier

"how many Boston Crab Meat were sold"

[how many {QUANTITYPERUNIT}]

what total quantity of {1} of products

[how many authors]

IsNotBooks

[how many names]

how many lastnames

[how much {PRODUCTNAME}]

[ how much stock of {1} | how much quantity of {1} ] *stock

[how old]

what age

[largest order]

largest subtotal

[located in new england]

region=MA

[located where]

located in postalcode region city address

[meaning of life]

LifeMeaning

[order total]

subtotal

[outstanding orders]

ShippedDate="##"

[over {#} {QuantityPerUnit}]

more than {#} {1}

[people who buy your products]

customers

[people who supply your products]

suppliers

[per month]

for each month

[placed over {#} orders]

more than {#} orders

[price per package]

price and quantityperunit

[product types]

categories

[products how many]

how many products

[products types]

categories

[quarter 1]

Q1

[quarter 2]

Q2

[quarter 3]

Q3

[quarter 4]

Q4

[reverse order]

reverse alphabetical order

[sales person]

employee

[salespeople]

employees

[salesperson]

employee

[select *]

get everything

[size of order]

subtotal

[subtotal by month]

for each month

[subtotal by quarter]

for each quarter

[sum of sales]

total extended price

[summarize {FIELD} by year]

show total {1} for each year

[the 1st quarter]

Q1

[the 2nd quarter]

Q2

[the 3rd quarter]

Q3

[the 4th quarter]

Q4

[the first quarter]

Q1

[the fourth quarter]

Q4

[the second quarter]

Q2

[the third quarter]

Q3

[thing]

product

[this year and last]

[this year and last | this year and last year] * last year

[under {#} {QuantityPerUnit}]

less than {#} {1}

[United States]

USA

[we sell]

product

[whare]

where

[what {Category}]

[what {1} | what {1} products] *what product<