<prompt> Write a query in PostgreSQL to list customers with orders in a particular month.Month: April 2021  <response>: Here is a sample query to list customers with orders in April 2021:SQLSELECT customers.name, customers.id, orders.order_dateFROM customersINNER JOIN ordersON customers.id orders.customer_idWHERE DATE_PARTmonth, orders.order_date 04 AND DATE_PARTyear, orders.order_date 2021ORDER BY orders.order_date; This query assumes the existence of two tables, customers and orders. The join links the tables based on the customer_id field of the orders table and the id field of the customers table.The WHERE clause filters the results to include only orders from April 2021 using the DATE_PART function to extract the month and year from the order_date column of the orders table.The resulting list of customers is sorted by order_date in ascending order. You can modify the SELECT statement to retrieve and display any desired columns from the joined tables. 