We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
In the store dataset, the target entity is orderlines.
Currently, we can generate a problem like
SELECT count(*) from orderlines inner join products where products.price > 22.99
Which basically predicts how many individual products with a price > 22.99 will be ordered in a month.
With a having operation, we would be able to generate problems like
SELECT count(orderlines.orderid) from orderlines inner join products group by orderlines.orderid having avg(products.price) > 22.99
Which predicts how many orders there will be such that average product price in each order is > 22.99 in a month.
The text was updated successfully, but these errors were encountered:
No branches or pull requests
In the store dataset, the target entity is orderlines.
Currently, we can generate a problem like
SELECT count(*) from orderlines inner join products where products.price > 22.99Which basically predicts how many individual products with a price > 22.99 will be ordered in a month.
With a having operation, we would be able to generate problems like
SELECT count(orderlines.orderid) from orderlines inner join products group by orderlines.orderid having avg(products.price) > 22.99Which predicts how many orders there will be such that average product price in each order is > 22.99 in a month.
The text was updated successfully, but these errors were encountered: