<prompt> Generate a query to find all customers who have made more than 50 purchasesGiven table: customer and sale.  <response>: Assuming the schema of the tables is as follows: Table customer: - customer_id primary key - name - ... Table sale: - sale_id primary key - customer_id foreign key referencing customer - ... A possible SQL query to find all customers who have more than 50 purchases could be:sqlSELECT customer.customer_id, customer.nameFROM customer JOIN saleON customer.customer_id sale.customer_idGROUP BY customer.customer_idHAVING COUNT 50 