3 replies to this topic

[Tank314]

SELECT märke, avg( pris ) 
FROM bil
WHERE märke =  "SAAB"
OR märke =  "Volvo"

It gives me average price only for Volvo but not for SAAB.

[wim DC]

Better add

GROUP BY märke 

to your query.

[ace26]

Tank314 said:

SELECT märke, avg( pris ) 

FROM bil

WHERE märke =  "SAAB"

OR märke =  "Volvo"

It gives me average price only for Volvo but not for SAAB.

Replace the "OR" in the WHERE clause with an "AND" if you want the average of both combined.

[WingedPanther]

Replacing OR with AND would result in no results.