SELECT T1.customer_id, T1.first_name, COUNT(*) FROM Customers AS T1 JOIN bookings AS T2 ON T1.customer_id = T2.customer_id GROUP BY T1.customer_id
Berapa banyak pemesanan yang dilakukan setiap pelanggan?Sebutkan ID Pelanggan, Nama Depan, dan Hitungan.
CREATE TABLE bookings (customer_id VARCHAR); CREATE TABLE Customers (customer_id VARCHAR, first_name VARCHAR)