KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I need to use an alias in the WHERE clause, but It keeps telling me that its an unknown column. Is there any way to get around this issue? I need to select records that have a rating higher than x. Rating is calculated as the following alias: sum(reviews.rev_rating)/count(reviews.rev_id) as avg_rating
Tags (comma-separated)
Save Edits
Cancel