How to find the total amount of a Customers Sales By using Sql Query ?

How to find total amount in Sales Table of One Customer in sql query ?

Select C.CustomerId,C.CustomerName, sum(S.Amount) as Total  From Customers C,Sales S
where C.CustomerId=S.CustomerId
group by C.CustomerId,C.CustomerName