I have a question about syntax of the code below. I'm trying to make 2 selects ,one of them is to calculate daily sales ,but without success.The error i got is

> 
> ORA-00936: missing expression
> 
> 
> 

```
SELECT
    sale_kol * prod_price AS total
FROM nalichni_produkti,sale_product
    (
        SELECT
            product.prod_name,
            n.prod_price,
            sale_product.sale_kol,
            klient.klient_name,
            sale.dates
        FROM
                 product
            INNER JOIN sale ON sale.sale_id = product.prod_id
            INNER JOIN klient ON klient.klient_id = sale.klient_klient_id
            INNER JOIN nalichni_produkti n ON n.product_prod_id = product.prod_id
            INNER JOIN sale_product ON sale_product.sale_sale_id = sale.sale_id
        WHERE
            sale.dates BETWEEN ( '&Data1' ) AND ( '&Data2' )
    ) 
WHERE
    nalichni_produkti.product_prod_id = sale_product.sale_sale_id;

```