Databases
StackOverflow2013
Postsdbo
POSQL query for Calculating Total No. of Orders per Day?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSQL query for Calculating Total No. of Orders per Day?
    text
    copied!<p>Can anyone post a SQL query for Calculating Total No. of Orders per Day?</p> <p>Here are the Columns along with their data in my Database.</p> <hr> <pre><code>order_id order_placed_date order_total - 1 12/30/2008 12:06:24 AM 2499.99 - 2 2/3/2009 1:57:17 AM 199.99 - 3 2/3/2009 1:58:27 AM 449.99 - 4 5/3/2009 1:58:48 AM 299.99 - 5 6/3/2009 2:00:31 AM 359.94 - 6 6/3/2009 2:01:47 AM 279.97 - 7 6/3/2009 2:02:31 AM 1359.94 - 9 7/1/2009 2:21:18 PM 5099.98 - 10 7/1/2009 2:21:36 PM 2621.97 - 11 7/2/2009 2:22:18 PM 2169.95 - 12 7/3/2009 2:23:29 PM 2249.95 - 13 7/4/2009 2:24:24 PM 5509.95 - 14 7/5/2009 12:15:17 AM 449.99 - 15 7/5/2009 12:18:08 AM 2299.99 - 16 7/5/2009 12:18:28 AM 3999.99 - 17 7/5/2009 12:18:45 AM 1939.99 - 18 7/5/2009 11:58:07 PM 39.99 - 19 7/6/2009 12:00:42 AM 1899.99 - 20 7/6/2009 12:01:00 AM 3999.99 - 21 7/7/2009 12:06:38 AM 199.99 - 22 7/7/2009 12:08:31 AM 1143.97 - 23 7/7/2009 12:09:13 AM 449.99 - 26 7/15/2009 1:30:03 PM 5469 - 27 7/15/2009 2:14:24 PM 329.97 - 28 7/15/2009 6:18:47 PM 5469 - 29 7/15/2009 10:17:36 PM 39.99 </code></pre> <hr> <p>For e.g. there are 2 orders in the month of Febuary 2009</p> <pre><code> - 2 2/3/2009 1:57:17 AM 199.99 - 3 2/3/2009 1:58:27 AM 449.99 </code></pre> <p><strong>I need a sql query which would calculate and show the total amount per day. So for 3rd of Feb 2009, the total would be 699.98</strong></p> <p>I need to display Total Order Amount per day in a Chart</p> <p>If it would be easier to do it with PHP, do mention it as well.</p> <hr> <p><strong>UPDATE:</strong><br> I would like to clarify that I needed the Total Amount Per Day in the Present Month. I forgot to mention that in my initial question.</p> <p>So i udpated Peter's query to get Total No. of Orders + Total Amount per Day in this Month.</p> <p>Please, let me know if it needs any correction or is there a better and shorter way of doing it.</p> <hr> <pre><code>SELECT date(order_placed_date), COUNT(order_id) AS num_orders, SUM(order_total) AS daily_total FROM orders WHERE order_placed_date&gt;=date_sub(current_date, INTERVAL 31 DAY) GROUP BY date(order_placed_date) </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload