Número de consultas total de hoy por hotel

[Libras]

1 tabla
-----

Código SQL:

SELECT COUNT(*) FROM tabla1 AS t1
WHERE tabla1.fecha BETWEEN fecha_inicial AND fecha_final
 

3 tablas

Código SQL:

SELECT COUNT(*) FROM tabla1 AS t1
LEFT JOIN tabla2 AS t2 ON (t1.id=t2.id)
LEFT JOIN tabla3 AS t3 ON (t1.id=t3.id)
WHERE tabla1.fecha BETWEEN fecha_inicial AND fecha_final