question

seharzia avatar image
seharzia asked

Sql query

Customer(c_id, name, state) Order(o_id, order_date, c_id) ProductOrder(o_id, p_id, quantity) Write a query to display the total number of orders and, of that total, the number of orders placed on Monday, Tuesday, Wednesday, Thursday, and Friday
ordering
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image JohnM commented ·
An excellent point. And just after I posted an answer which I've removed until we see what the OP says. ;-)
2 Likes 2 ·
@SQLShark avatar image @SQLShark commented ·
This looks like a college/school etc question. What have you tried so far?
1 Like 1 ·

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
I would suggest looking at a few places in the [Books Online][1]; GROUP BY, ORDER, DATEPART. That'll get you started. If you then get stuck, come back with the specifics of what's not working. [1]: http://technet.microsoft.com/en-us/library/ms130214.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.