Consider the following table sales which contains data on sales transactions for a company:

Get the total sales amount for customer with ID $1003.$

SQL Table with the following schema $-$

Tables Schema as Below:

sales

columnName dataType

id INTEGER

customer$\_$id INTEGER

product$\_$id INTEGER

sale$\_$date DATE

amount DECIMAL