Please read the following table in Markdown format and then answer the question according to the table. Table cells in one row are seperated by '|', and different rows are seperated by '
'.

Table:
| Name | Years | Area | Authority | Decile | Roll |
| --- | --- | --- | --- | --- | --- |
| Browns Bay School | 1–6 | Browns Bay | State | 10 | 610.0 |
| Glamorgan School | 1–6 | Torbay Heights | State | 10 | 507.0 |
| Gulf Harbour School | 1–8 | Gulf Harbour | State | 10 | 402.0 |
| Long Bay School | 1–6 | Long Bay | State | 10 | 318.0 |
| Mairangi Bay School | 1–6 | Mairangi Bay | State | 10 | 461.0 |
| Murrays Bay Intermediate | 7–8 | Murrays Bay | State | 10 | 963.0 |
| Murrays Bay School | 1–6 | Murrays Bay | State | 10 | 649.0 |
| Northcross Intermediate | 7–8 | Northcross | State | 10 | 1039.0 |
| Orewa North Primary School | 1–6 | Orewa | State | 8 | 295.0 |
| Orewa Primary School | 1–6 | Orewa | State | 8 | 299.0 |
| Red Beach School | 1–6 | Red Beach | State | 9 | 639.0 |
| Sherwood School | 1–6 | Northcross | State | 10 | 438.0 |
| Silverdale School | 1–8 | Silverdale | State | 9 | 420.0 |
| St John's School | 1–6 | Mairangi Bay | State integrated | 10 | 306.0 |
| Stanmore Bay School | 1–6 | Stanmore Bay | State | 8 | 473.0 |
| Stella Maris Primary School | 1–8 | Silverdale | State integrated | 10 | 314.0 |
| Torbay School | 1–6 | Torbay | State | 10 | 484.0 |
| Wentworth Primary | 1–6 | Gulf Harbour | Private | n/a | 55.0 |
| Whangaparaoa School | 1–6 | Manly | State | 9 | 698.0 |
Question:
Which school has a state authority and a roll of 318?
Answer:
Long Bay School