This query returns the results below.

```
Select BookTitle,TotalNumberInStock 
From CurrentStock
Where (Year<2000 OR Year >2010);

```

**Table 1**

```
BookTitle               TotalNumberInStock
The Tower               2
Orange Goblins          1
The future of Metal     3
Chronicles of the Banjo 2
Opera                   4
Advanced SQL            5
The GAA                 4

```

I want to write a subquery that sums the TotalNumber In Stock so I used this statement:

```
Select Sum(TotalNumberInstock)
From 
(
   Select BookTitle,TotalNumberInStock 
   From CurrentStock
   Where (Year<2000 OR Year >2010)
);

```

I get an error saying:

> 
> Incorrect syntax near ';'. 
> 
> 
> 

What is wrong with this code?