Home > Net >  ORACLE SQL number of customers who have ordered something on a date
ORACLE SQL number of customers who have ordered something on a date

Time:01-16

I have 2 tables involved, the "customers" table and the "orders" table.

The "customers" table has the following columns:

Customerid, companyname, contactname, contactittle, addresses, city

The "Orders" table has the following columns:

orderid, customerid, employeeid, orderdate, shippeddate, shipname

I have to do where the number of customers who have ordered a product in the year 97 comes out.

It should be something like

Number of clients 20

I have tried the following code, but I think it is wrong for the following two reasons

1-I think that like '

  • Related