SQL online test 2

Table "Customers"

CustomerID	FirstName	LastName	Email	ReferredBy	Phone
1	John	Smith	John.Smith@yahoo.com	NULL	626 222-2222
2	Steven	Goldfish	goldfish@fishhere.net	1	323 455-4545
3	Paula	Brown	pb@herowndomain.org	2	416 323-3232
4	James	Smith	jim@supergig.co.uk	1	416 323-8888

Table "Books"

CustomerID	Date	Books
2	2014-06-05	2
1	2005-06-02	10
3	2014-07-07	50
3	2014-08-12	10
4	2014-09-09	15

Select the email of each customer and the total respective number of books each has bought. (email,number of books)

The output should be

Email                  TotalBooks  
---------------------  ----------  
jim@supergig.co.uk     15          
John.Smith@yahoo.com   10          
pb@herowndomain.org    60          
goldfish@fishhere.net  2

SQL online test 2

Table "Customers"

Table "Books"

Select the email of each customer and the total respective number of books each has bought. (email,number of books) The output should be

DB Connection Settings

Select the email of each customer and the total respective number of books each has bought. (email,number of books)

The output should be