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

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 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.