Hi Guys,

I'm having trouble thinking of ideas for queries that would go with an online purchasing system. The queries must be partially complex (i.e. not just a simple insert query ).

I can easily write the queries myself but i just need a little help thinking of useful queries.

A query for an 'Invoice' for example is a perfect idea as it implements table joins etc.

Possible other queries are:
Find all customers that have spent a total of more than X amount
Find all delivery address's that X customer has sent items to
Track an order to see if items have been sent yet or not.
etc....

If anyone else can think of a few other ideas i'd be very grateful :-)

thx for reading :-)

--Philkills

online purchasing sytem? or homework assignment?

total sales by category for the previous month
average price of backlogged orders (product not in stock)
most popular item (by quantity sold, not total price)

easiest technique...
open a copy of Access, create yuour tables
create the realtionships
open up the query designer
add the required constraints....
run the query, prove it works
open up the query in SQL mode, copy and paste the SQL to your homework assignment paper
....jobsagoodun



... requires minimum thought and creativity, and absolutely no proof that you have understood the concepts behid joins, where clauses etc...

Some nice ideas there thx ^^


and lol....

a nice way to cheat i suppose... but i do actually understand joins etc ;p

Variations on these:
- Total sales for all foregoing months
- Top ten most popular items
- Most popular category per client (useful for better direct advertising ;-)
- Top ten clients in terms of the amount spent
- Same question, but now in 12 columns, for each of the last 12 months

- Customer's year to date sales (purchases) compared with last year's year to date sales (purchases).