Daily sales report

Daily sales report

Medium SQL DQL 25 views
Explanation Complexity

Problem Statement

Make a simple daily sales report for the last 7 days. From Orders(order_date, total_amount), show order_date and total sales per day.

Input Format

SQL query

Output Format

Result set

Example

Orders(order_date, total_amount)
7 rows

Constraints

Assume PostgreSQL-style interval

Input / Output Format

Input Format
SQL query
Output Format
Result set
Constraints
Assume PostgreSQL-style interval

Examples

Input:
Orders(order_date, total_amount)
Output:
7 rows

Example Solution (Public)

SQL 
SELECT order_date, SUM(total_amount) AS total_sales FROM Orders WHERE order_date >= (CURRENT_DATE - INTERVAL '7 days') GROUP BY order_date ORDER BY order_date;

Official Solution Code

SELECT order_date, SUM(total_amount) AS total_sales FROM Orders WHERE order_date >= (CURRENT_DATE - INTERVAL '7 days') GROUP BY order_date ORDER BY order_date;
Please login to submit solutions.
Editor
Output

                                        

                                    

                                    

                                        

                                                                                    
Please login to submit solutions.