SELECT * FROM payment p_outer WHERE amount > (SELECT AVG(amount) FROM payment p_inner WHERE p_outer.customer_id=p_inner.customer_id)
SELECT * FROM payment p_outer WHERE amount > (SELECT AVG(amount) FROM payment p_inner WHERE p_outer.customer_id=p_inner.customer_id)
To install DBIx::Cookbook, copy and paste the appropriate command in to your terminal.
cpanm DBIx::Cookbookperl -MCPAN -e shell
install DBIx::CookbookFor more information on module installation, please visit the detailed CPAN module installation guide.
| Global | |
|---|---|
| s | Focus search bar |
| ? | Bring up this help dialog |
| GitHub | |
|---|---|
| g p | Go to pull requests |
| g i | go to github issues (only if github is preferred repository) |
| POD | |
|---|---|
| g a | Go to author |
| g c | Go to changes |
| g i | Go to issues |
| g d | Go to dist |
| g r | Go to repository/SCM |
| g s | Go to source |
| g b | Go to file browse |
| Search terms | |
|---|---|
| module: (e.g. module:Plugin) | |
| distribution: (e.g. distribution:Dancer auth) | |
| author: (e.g. author:SONGMU Redis) | |
| version: (e.g. version:1.00) |