-- Database schema
| address_status : status_id [ INTEGER ] primary_key , address_status [ TEXT ] | author : author_id [ INTEGER ] primary_key , author_name [ TEXT ] | book_language : language_id [ INTEGER ] primary_key , language_code [ TEXT ] , language_name [ TEXT ] | country : country_id [ INTEGER ] primary_key , country_name [ TEXT ] | address : address_id [ INTEGER ] primary_key , street_number [ TEXT ] , street_name [ TEXT ] , city [ TEXT ] , country_id [ INTEGER ] address.country_id = country.country_id | customer : customer_id [ INTEGER ] primary_key , first_name [ TEXT ] , last_name [ TEXT ] , email [ TEXT ] | customer_address : customer_id [ INTEGER ] customer_address.customer_id = customer.customer_id , address_id [ INTEGER ] customer_address.address_id = address.address_id , status_id [ INTEGER ] | order_status : status_id [ INTEGER ] primary_key , status_value [ TEXT ] | publisher : publisher_id [ INTEGER ] primary_key , publisher_name [ TEXT ] | book : book_id [ INTEGER ] primary_key , title [ TEXT ] , isbn13 [ TEXT ] , language_id [ INTEGER ] book.language_id = book_language.language_id , num_pages [ INTEGER ] , publication_date [ DATE ] , publisher_id [ INTEGER ] book.publisher_id = publisher.publisher_id | book_author : book_id [ INTEGER ] book_author.book_id = book.book_id , author_id [ INTEGER ] book_author.author_id = author.author_id | shipping_method : method_id [ INTEGER ] primary_key , method_name [ TEXT ] , cost [ REAL ] | cust_order : order_id [ INTEGER ] primary_key , order_date [ DATETIME ] , customer_id [ INTEGER ] , shipping_method_id [ INTEGER ] , dest_address_id [ INTEGER ] | order_history : history_id [ INTEGER ] primary_key , order_id [ INTEGER ] , status_id [ INTEGER ] , status_date [ DATETIME ] | order_line : line_id [ INTEGER ] primary_key , order_id [ INTEGER ] , book_id [ INTEGER ] , price [ REAL ] |
-- -- How many books are in English?

SELECT COUNT(*) FROM book AS T1 INNER JOIN book_language AS T2 ON T1.language_id = T2.language_id WHERE T2.language_name = 'English';