SQL:
Eisha Adil
I worked on an e-commerce database in MySQL to analyze quarterly sales. The database includes three tables:
Orders, Products, and customers. I need an SQL query to calculate the total revenue generated for each product category in the last quarter (July to September 2024). The query should return the product category and total revenue, sorted by revenue in descending order. Please optimize the query for large datasets."Like this project
Posted Nov 16, 2024
I am working on an e-commerce database in MySQL to analyze quarterly sales. The database includes three tables: Orders, Products, and Customers. I need an SQL q
Likes
0
Views
0
Tags
