Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sum of customer transactions
- 1 Deal Certificate int(3)
- 2 Purchase Price decimal(4,2)
- 3 Purchase Date timestamp
- 4 Serial Number varchar(9)
- 5 Name varchar(23)
- 6 Email varchar(42)
- SELECT *
- FROM `PURCHASES`
- WHERE `Purchase Date`
- between '2012-01-01' and '2012-01-31'
- order by email
- 345 36.00 2012-01-17 16:42:33 7757-3097 T T xxx@gmail.com
- 327 6.00 2012-01-05 10:40:57 0223-3945 R T yyy@gmail.com
- 329 12.00 2012-01-02 04:54:45 1087-7072 P B zzz@msn.com
- 294 7.00 2012-01-02 04:59:11 4144-2426 P B zzz@msn.com
- 285 6.00 2012-01-02 05:12:39 8027-1641 P B zzz@msn.com
- 1079 21.00 2012-01-02 05:05:07 2447-7971 P B zzz@msn.com
- 331 10.00 2012-01-02 19:14:38 3916-5434 y a aaa@aol.com
- 345 36.00 2012-01-17 16:42:33 7757-3097 T T xxx@gmail.com
- 327 6.00 2012-01-05 10:40:57 0223-3945 R T yyy@gmail.com
- 329 46.00 2012-01-02 04:54:45 1087-7072 P B zzz@msn.com
- 331 10.00 2012-01-02 19:14:38 3916-5434 y a aaa@aol.com
- 36.00 T T xxx@gmail.com
- 6.00 R T yyy@gmail.com
- 46.00 P B zzz@msn.com
- 10.00 y a aaa@aol.com
- select sum(`Purchase Price`) as total_sum, name, email from purchases
- where `Purchase Date` between '2012-01-01' and '2012-01-31'
- group by email, name
- order by email
- SELECT `Deal Certificate`,
- sum(`Purchase Price`) as sum_price
- `Purchase Date`,
- `Serial Number`,
- Name,
- Email
- FROM PURCHASES
- WHERE Purchase Date between '2012-01-01' and '2012-01-31'
- group by `Deal Certificate`
- order by email
Add Comment
Please, Sign In to add comment