Question

Write Sql query for given task

Task
: You are required to produce a report of customers who purchased products with list prices of more than $1,000. The report must contain customer first and last names, as well as the product name and their list prices. Customer information is stored in the CUSTOMERS table, which has the CUSTOMER_ID column as its primary key. The product name and list price details are stored in the PRODUCT_INFORMATION table with the PRODUCT_ID column as its primary key. Two other related tables may assist in generating the required report: the ORDERS table, which stores the CUSTOMER_ID and ORDER_ID]information, and the ORDER_ITEMS table, which stores the PRODUCT ID values associated with each ORDER ID.​

Answer 1

Answer:

The Customers table and Product_information table do not have a direct relationship with each other but there are two tables orders and order_items in betweent which connect customers and product infomation table. To get the cutomer details and