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 '