 Générer query pona koluka ba clients nionso oyo basali plus de 50 achats
Kokanisa ete schéma ya ba tableaux ezali boye : Client ya tableau : - client_id (clé primaire) - kombo - .... Vente ya tableau : - sale_id (clé primaire) - client_id (client ya référence ya clé ya poto) - ..... A possible SQL query mpo na koluka ba clients nionso oyo bazali na plus de 50 achats ekoki kozala: ```sql SELECT client.customer_id, client.name FROM client JOIN sale ON customer.customer_id = sale.customer_id GROUP PAR customer.customer_id HAVING COUNT(*) > 50 ```