SQL Recipes (Beta II)
A FREE cookbook for SQL queries and examples
Register FAQ Search Today's Posts Mark Forums Read

SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it.

Go Back   SQL Recipes a FREE cookbook of SQL queries and examples > SQL queries and examples > SQL - Questions and Answers
List all customers who ordered products where price of the item is $100 greater than average order? List all customers who ordered products where price of the item is $100 greater than average order?

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread
  #1 (permalink)  
Old 05-23-2006, 11:33 PM
alexfr alexfr is offline
Junior Member
  
Join Date: May 2006
Posts: 24
alexfr is on a distinguished road
Default MySQL dialect question:

List all customers who ordered products where price of the item is $100 greater than average order?

List all customers who ordered products where price of the item is $100 greater than the average price orders
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

ANSWER(S):

  #2 (permalink)  
Old 05-24-2006, 12:02 AM
alexfr alexfr is offline
Junior Member
  
Join Date: May 2006
Posts: 24
alexfr is on a distinguished road
Default SQL 92 answer. Re: List all customers who ordered products where price of the item is $100 greater than average order?
SELECT c.id, c.firstname, c.lastname
FROM customers c INNER JOIN orders o ON c.customer_id = c.customer_id
WHERE o.price >
(SELECT AVG(o.price) + 100
FROM orders o)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« List players by numbers of points? | List by ascending number of orders the customers that have placed more than 1 order? »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
List all customers from table customers that haven't made any order during year 2005? alexfr SQL - Questions and Answers 1 05-24-2006 12:04 AM
List by ascending number of orders the customers that have placed more than 1 order? alexfr SQL - Questions and Answers 1 05-24-2006 12:03 AM
List all customers whose name is present more than once in the table? alexfr SQL - Questions and Answers 1 05-24-2006 12:01 AM
List from particular customers with minum orders? alexfr SQL - Questions and Answers 1 05-23-2006 11:57 PM
list customers with average ordered quantities? alexfr SQL - Questions and Answers 1 05-23-2006 11:56 PM


All times are GMT. The time now is 05:03 AM.

Contact Us - SQL Recipes - Archive - Top

Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0
Copyright (c) 2006-2007 SQL Recipes

1 2 3 4 5 6 7