<prompt> Kuandika SQL query kwamba anarudi majina ya wateja wote na bidhaa wao kununuliwa.  <response>: Here is an example SQL query that could be used to return the names of all customers and the products they purchased:SELECT customers.name, products.name AS productFROM customers INNER JOIN orders ON customers.id orders.customer_idINNER JOIN order_items ON orders.id order_items.order_idINNER JOIN products ON order_items.product_id products.idThis example assumes that there are tables called customers, orders, order_items, and products, each with columns as follows:- The customers table includes a column called id which uniquely identifies each customer, and a column called name which holds the name of the customer- The orders table includes a column called id which uniquely identifies each order, and a column called customer_id which holds the ID of the customer who placed the order- The order_items table includes a column called order_id which references the ID of the order, and a column called product_id which references the ID of the product purchased- The products table includes a column called id which uniquely identifies each product, and a column called name which holds the name of the productThe query above first performs an INNER JOIN between the customers and orders tables, matching records where the customer_id in the orders table is the same as the id in the customers table. Then, it performs another INNER JOIN between the resulting records and the order_items table, matching records where the order_id in the order_items table is the same as the id in the orders table. Finally, the query performs one more INNER JOIN between the resulting records and the products table, matching records where the product_id in the order_items table is the same as the id in the products table.The resulting records will include the name of the customer from the customers table and the name of the product from the products table. The AS keyword is used to rename the products.name column to product in the result set. 