I was writing code for a DB browser for SQL Lite I wanted to see the total number of background checks in California when I executed it it gave me an error I wasn't sure why

New Database

Open Database

Write Changes

Database Structure

Browse Data

Edit

S$...$

$1$ SELECT SUM$(totals)AS$

$2$ TotalBackgroundChecks

$3$ FROM nics$-$checks$-$last$-$five$-$years

$4$ WHERE state $=$ 'Callfornia';

$1$ SELECT SUM$($totals$)$ AS

$2$ TotalBackgroundChecks

$3$ FROM nics$-$checks$-$last$-$flve$-$years

$4$ WHERE state $=$ 'California';

Bxecution finished with errors.

Result: near $"-"$: syntax error

At line $1$:

SMLFCT SUM $($totals$)$

FROM ntos$-$