suppose there are given tables that has particular attributes, and for example I need to find how many ordered a specific dish.. example: "How many fried chicken orders were made in 1 month?" How do I do the sql statement for this? Thanks for those who will help. :D

Recommended Answers

All 2 Replies

post here sturcture of all table related to your qery
then post sample data here and then tell us what output u expect from that sample data.

In addition to Urtrivedi, Please post what codes you have so far, and the errors you are getting

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.