Please do the followings for the conceptual design;
The startup is planning to make money by marketing research. Please write SQL queries for the following queries:
Find the names of farmers who produces most for each product.
Find the names of farmers who produces most grain for each city.
Find the pairs of products that can be grown in the same year (their plantation starts date and harvest date do not intersect)
Find the names of farmers who sells most for each product in the website.
Find the names of farmers who sells most grain for each city in the website.
Find the name(s) of farmers who make most money.
Find the names of farmers who sell products more than they produces
Find the names of markets with the biggest budget in each city.
Find the names of markets who buys most for each product type.
List 3 products that the website makes most money
Find the names of markets who buys products costing higher than their budgets
Find the total number of users of website.
