Question

Find out the following written SQL Queries with their particular outputs,

1.Marie owns a shop called “Parker General Store”. In the store she has multiple products. To gain a ratio
about the product & their quantity she wants to know about the products information. Help her to get the
Consumer name with product Id who has shopped within the last three months of the present year from her
shop.

2.Marie has observed an issue that people are very much concerned about the origin of the product which
they buy. So she was thinking of having a medium to get the origin of the product with their quantity in
respect to the maximum number of the origin. Help her to get that.

3.From the table given above how to get the name of the consumers who have bought the same products
with different quantities also find out the prices.

4.Marie wants to give a price for the customer who has shopped the maximum in the last month. Find
out the consumer name who has shopped the maximum in the last month.

5.In order to get the order the information about the maximum product quantity with their particular order
date & price. Write down a query

Answer 1

Answer:

try yugin bh kbhi khun bhigi jg yukt gf in khu inhonne arth try h knth duriyon huyi but further eyuutgjhjjhhjdtudy