Ufdjrw

In musical terms, what properties are varied by the human voice to produce different words / syllables?

Any stored/leased 737s that could substitute for grounded MAXs?

Where did Ptolemy compare the Earth to the distance of fixed stars?

Short story about astronauts fertilizing soil with their own bodies

The test team as an enemy of development? And how can this be avoided?

Trying to understand entropy as a novice in thermodynamics

Find general formula for the terms

The Nth Gryphon Number

My mentor says to set image to Fine instead of RAW — how is this different from JPG?

Flight departed from the gate 5 min before scheduled departure time. Refund options

Why can't fire hurt Daenerys but it did to Jon Snow in season 1?

Why did Bronn offer to be Tyrion Lannister's champion in trial by combat?

New Order #6: Easter Egg

Google .dev domain strangely redirects to https

Pointing to problems without suggesting solutions

Did any compiler fully use 80-bit floating point?

Does the Rock Gnome trait Artificer's Lore apply when you aren't proficient in History?

Sally's older brother

Was the pager message from Nick Fury to Captain Marvel unnecessary?

Is this Half dragon Quaggoth Balanced

How to make triangles with rounded sides and corners? (squircle with 3 sides)

First paper to introduce the "principal-agent problem"

Marquee sign letters

Can gravitational waves pass through a black hole?

error code 1064 when i try to use greater than for aggregate

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

 (SELECT discount_percent
 FROM products
 WHERE discount_percent > AVG(discount_percent)

I'm not sure what im doing wrong

mysql sql

share|improve this question

edited Mar 9 at 1:06

mandy drew

asked Mar 9 at 0:34

mandy drewmandy drew

11

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Your parentheses aren't balanced.
  
  – Barmar
  Mar 9 at 0:40
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  The subquery should just be (SELECT AVG(discount_percent) FROM products)
  
  – Barmar
  Mar 9 at 0:40
  

  
  
  
  

add a comment | 

0

 (SELECT discount_percent
 FROM products
 WHERE discount_percent > AVG(discount_percent)

I'm not sure what im doing wrong

mysql sql

share|improve this question

edited Mar 9 at 1:06

mandy drew

asked Mar 9 at 0:34

mandy drewmandy drew

11

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Your parentheses aren't balanced.
  
  – Barmar
  Mar 9 at 0:40
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  The subquery should just be (SELECT AVG(discount_percent) FROM products)
  
  – Barmar
  Mar 9 at 0:40
  

  
  
  
  

add a comment | 

 (SELECT discount_percent
 FROM products
 WHERE discount_percent > AVG(discount_percent)

I'm not sure what im doing wrong

mysql sql

share|improve this question

edited Mar 9 at 1:06

mandy drew

asked Mar 9 at 0:34

mandy drewmandy drew

11

 (SELECT discount_percent
 FROM products
 WHERE discount_percent > AVG(discount_percent)

share|improve this question

edited Mar 9 at 1:06

mandy drew

asked Mar 9 at 0:34

mandy drewmandy drew

11

share|improve this question

edited Mar 9 at 1:06

mandy drew

asked Mar 9 at 0:34

mandy drewmandy drew

11

asked Mar 9 at 0:34

mandy drewmandy drew

11

asked Mar 9 at 0:34

mandy drewmandy drew

11

2 Answers
2

active

oldest

votes

2

WHERE discount_percent >
 (SELECT discount_percent
 FROM products
 WHERE discount_percent > AVG(discount_percent)

should be:

WHERE discount_percent > (SELECT AVG(discount_percent) FROM products)

You're missing a closing parenthesis after the subquery. But a bigger problem is that you can't use an aggregation function in the WHERE clause, because aggregation is done after selecting the rows. Also, you need to make the query return just one result so it can be compared with >.

share|improve this answer

edited Mar 9 at 4:16

Gordon Linoff

800k37321426

answered Mar 9 at 0:43

BarmarBarmar

438k36262366

add a comment | 

1

WHERE discount_percent > AVG(discount_percent)

probably needs to be changed to
HAVING discount_percent > AVG(discount_percent)

The HAVING clause is used to filter on aggregate functions, such as the AVG you are calling.

For some more documentation on this, check out this link: http://www.mysqltutorial.org/mysql-having.aspx

share|improve this answer

answered Mar 9 at 0:41

Jerry M.Jerry M.

7931828

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55072837%2ferror-code-1064-when-i-try-to-use-greater-than-for-aggregate%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

2

WHERE discount_percent >
 (SELECT discount_percent
 FROM products
 WHERE discount_percent > AVG(discount_percent)

should be:

WHERE discount_percent > (SELECT AVG(discount_percent) FROM products)

You're missing a closing parenthesis after the subquery. But a bigger problem is that you can't use an aggregation function in the WHERE clause, because aggregation is done after selecting the rows. Also, you need to make the query return just one result so it can be compared with >.

share|improve this answer

edited Mar 9 at 4:16

Gordon Linoff

800k37321426

answered Mar 9 at 0:43

BarmarBarmar

438k36262366

add a comment | 

2

WHERE discount_percent >
 (SELECT discount_percent
 FROM products
 WHERE discount_percent > AVG(discount_percent)

should be:

WHERE discount_percent > (SELECT AVG(discount_percent) FROM products)

You're missing a closing parenthesis after the subquery. But a bigger problem is that you can't use an aggregation function in the WHERE clause, because aggregation is done after selecting the rows. Also, you need to make the query return just one result so it can be compared with >.

share|improve this answer

edited Mar 9 at 4:16

Gordon Linoff

800k37321426

answered Mar 9 at 0:43

BarmarBarmar

438k36262366

add a comment | 

WHERE discount_percent >
 (SELECT discount_percent
 FROM products
 WHERE discount_percent > AVG(discount_percent)

should be:

WHERE discount_percent > (SELECT AVG(discount_percent) FROM products)

You're missing a closing parenthesis after the subquery. But a bigger problem is that you can't use an aggregation function in the WHERE clause, because aggregation is done after selecting the rows. Also, you need to make the query return just one result so it can be compared with >.

share|improve this answer

edited Mar 9 at 4:16

Gordon Linoff

800k37321426

answered Mar 9 at 0:43

BarmarBarmar

438k36262366

WHERE discount_percent >
 (SELECT discount_percent
 FROM products
 WHERE discount_percent > AVG(discount_percent)

WHERE discount_percent > (SELECT AVG(discount_percent) FROM products)

share|improve this answer

edited Mar 9 at 4:16

Gordon Linoff

800k37321426

answered Mar 9 at 0:43

BarmarBarmar

438k36262366

edited Mar 9 at 4:16

Gordon Linoff

800k37321426

edited Mar 9 at 4:16

Gordon Linoff

800k37321426

answered Mar 9 at 0:43

BarmarBarmar

438k36262366

answered Mar 9 at 0:43

BarmarBarmar

438k36262366

1

WHERE discount_percent > AVG(discount_percent)

probably needs to be changed to
HAVING discount_percent > AVG(discount_percent)

The HAVING clause is used to filter on aggregate functions, such as the AVG you are calling.

For some more documentation on this, check out this link: http://www.mysqltutorial.org/mysql-having.aspx

share|improve this answer

answered Mar 9 at 0:41

Jerry M.Jerry M.

7931828

add a comment | 

1

WHERE discount_percent > AVG(discount_percent)

probably needs to be changed to
HAVING discount_percent > AVG(discount_percent)

The HAVING clause is used to filter on aggregate functions, such as the AVG you are calling.

For some more documentation on this, check out this link: http://www.mysqltutorial.org/mysql-having.aspx

share|improve this answer

answered Mar 9 at 0:41

Jerry M.Jerry M.

7931828

add a comment | 

WHERE discount_percent > AVG(discount_percent)

probably needs to be changed to
HAVING discount_percent > AVG(discount_percent)

The HAVING clause is used to filter on aggregate functions, such as the AVG you are calling.

For some more documentation on this, check out this link: http://www.mysqltutorial.org/mysql-having.aspx

share|improve this answer

answered Mar 9 at 0:41

Jerry M.Jerry M.

7931828

share|improve this answer

answered Mar 9 at 0:41

Jerry M.Jerry M.

7931828

answered Mar 9 at 0:41

Jerry M.Jerry M.

7931828

answered Mar 9 at 0:41

Jerry M.Jerry M.

7931828