# SQL Exercise: Number of orders booked for each day

## SQL Formatting Output: Exercise-2 with Solution

From the following table, write a SQL query to find the number of orders booked for each day. Return the result in a format like "For 2001-10-10 there are 15 orders".

*Sample table*: orders

**Sample Solution:**

```
SELECT ' For',ord_date,',there are',
COUNT (ord_no),'orders.'
FROM orders
GROUP BY ord_date;
```

**Output of the Query:**

?column? ord_date ?column? count ?column? For 2012-04-25 ,there are 1 orders. For 2012-06-27 ,there are 1 orders. For 2012-07-27 ,there are 1 orders. For 2012-08-17 ,there are 2 orders. For 2012-09-10 ,there are 3 orders. For 2012-10-05 ,there are 2 orders. For 2012-10-10 ,there are 2 orders.

**Code Explanation:**

The query in SQL retrieves data from the 'orders' table and returns the information: The string "For", the column ord_date, the string ",there are", the count of the column ord_no, calculated using the COUNT function and grouped by ord_date, and the string "orders."

In the end, the final result that displays the message "For (order_date), there are (count of order_no) orders." for each unique order_date value.

**Relational Algebra Expression:**

**Relational Algebra Tree:**

**Explanation :**

**Visual presentation :**

## Practice Online

## Query Visualization:

**Duration:**

**Rows:**

**Cost:**

**Have another way to solve this solution? Contribute your code (and comments) through Disqus.**

**Previous SQL Exercise:** Salesmen commission with the percent sign (%).

**Next SQL Exercise:** Display orders after sorting orders by order number.

**What is the difficulty level of this exercise?**

Test your Programming skills with w3resource's quiz.

**Weekly Trends**- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join