Question: Consider the following schema for a fictional Ecommerce database: - customers: customer _ id , first _ name, last _ name, email, age - orders:

Consider the following schema for a fictional Ecommerce database:
-customers: customer_id, first_name, last_name, email, age
- orders: order_id, customer_id, order_date, total_amount - order_items: order_item_id, order_id, product_id, quantity
- products: product_id, product_name, unit_price
Write an SQL query to find the total revenue generated from each customer, along with their full names ("first_name last_name"), ordered by total revenue in descending order.Only include customers who have made at least 2 orders.
Output: customer_name, total_revenue Note: Use SELECT * FROM TABLE_NAME to explore the data if required.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!