Sql issue

[prolife]

Hello

 

please i dont know what went wrong ;this SQL is meant to count provided that this conditions are true.

 

i want to count the total number of rooms that were booked for in a particular month.

Please what is the right syntax to use when selecting from two different tables and then counting the total number of occurance.

 

Here is the SQL i came up with but its messig up.

SELECT  (SELECT COUNT(*) FROM `rooms`) (SELECT COUNT(*) FROM `order`) AS `total_rooms` FROM `rooms` WHERE `order`.`checkin`>'$real_date' AND `rooms`.`cond` ='available'

[Barand]

SELECT COUNT(DISTINCT room_id) as rooms_booked
FROM order
WHERE MONTH(checkin) = $month

If you want the number of room bookings rather the number of rooms the remove "DISTINCT" in the above query