从一个表中选择，从另一个表中进行计数

尝试改变…的喜欢

count(select * from bookings where b.id_customer = c.id)

…至…

(select count(*) from bookings where b.id_customer = c.id)