This question focus to the COUNT result
1st query will show the COUNT with date condition.
2nd query will show the COUNT without date condition.
Now I need a query which make the COUNT result in 1st query without date condition which is : COUNT(c.CustomerID) > ONLY with condition b.BookingCustomerID=c.CustomerID (without date condition)
c.CustomerTelephone, b.* > with condition WHERE b.BookingCustomerID=c.CustomerID AND BookingDate LIKE '%2019-05-04%'
Thanks.
SELECT COUNT(c.CustomerID), c.CustomerTelephone, b.*
FROM Booking b, Customer c
WHERE b.BookingCustomerID=c.CustomerID
AND BookingDate LIKE '%2019-05-04%'
GROUP BY c.CustomerID
SELECT COUNT(c.CustomerID), c.CustomerTelephone, b.*
FROM Booking b, Customer c
WHERE b.BookingCustomerID = c.CustomerID
GROUP BY c.CustomerID