如何使用此问题创建此查询？ [英] How do I create this query with this question?
问题描述
1.显示产品ID（通过将'PR'替换为ProductId的'Product'获得），产品名称（从大写格式的产品名称获得），MaterialName和购买的平均产品（从购买的产品的平均数量获得）对于价格超过20000且平均产品购买量大于所有销售交易数量平均值的产品。
（别名子查询）
2.Display DistributorName，Distributor Phone（在DistributorPhone上从'08'替换为'+628'），DistributorAddress和PurchaseDate为每个在购买交易中处理购买交易最多变化的产品的经销商。
（别名子查询）
你可以给我查询来完成这个问题....
我尝试了什么：
i甚至不了解这个问题我仍然是新手
i甚至没有了解这个问题我还是新手
1.Display Product Id (obtained by replacing ‘PR’ into ‘Product ’ of ProductId), Product Name (obtained from product name in uppercase format), MaterialName, and Average Product Purchased (obtained from average quantity of product purchased) for product which price is more than 20000 and Average Product Purchased is greater than average of all sales transaction quantity.
(alias subquery)
2.Display DistributorName, Distributor Phone (obtained from replace ‘08’ to ‘+628’ on DistributorPhone), DistributorAddress, and PurchaseDate for every distributor whose handle purchase transaction with the most variant product in a purchase transaction.
(alias subquery)
can you give me the query to finish this question please....
What I have tried:
i dont even understand about this question iam still newbie
i dont even understand about this question iam still newbie
推荐答案
不，我们不这样做。我们不做你的功课：这是有原因的。它就是为了让你思考你被告知的事情，并试着理解它。它也在那里，以便您的导师可以识别您身体虚弱的区域，并将更多的注意力集中在补救措施上。
亲自尝试，你可能会发现它不是和你想的一样困难！
如果遇到具体问题，请询问相关问题，我们会尽力提供帮助。但我们不打算为你做这一切！
No, we don't do that. We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.
Try it yourself, you may find it is not as difficult as you think!
If you meet a specific problem, then please ask about that and we will do our best to help. But we aren't going to do it all for you!
你能给我吗？请完成这个问题的查询....
i甚至不了解这个问题我仍然是新手
can you give me the query to finish this question please....
i dont even understand about this question iam still newbie
你需要和你谈谈的是你的老师。
家庭工作问题是你在现实生活中必须解决的问题的简化版本，他们的目的是学习和练习。
我们不做你的HomeWork。
HomeWork不会测试你乞求别人做你的工作的技巧，它是让您思考并帮助您的老师检查您对所学课程的理解以及您应用这些课程时遇到的问题。
你的任何失败都会帮助你的老师发现你的弱点并设定补救措施。
所以，试一试，重读你的课程并开始工作。如果您遇到特定问题，请展示您的代码并解释这个问题，我们可能会提供帮助。
The one you need to talk to is your teacher.
HomeWork problems are simplified versions of the kind of problems you will have to solve in real life, their purpose is learning and practicing.
We do not do your HomeWork.
HomeWork is not set to test your skills at begging other people to do your work, it is set to make you think and to help your teacher to check your understanding of the courses you have taken and also the problems you have at applying them.
Any failure of you will help your teacher spot your weaknesses and set remedial actions.
So, give it a try, reread your lessons and start working. If you are stuck on a specific problem, show your code and explain this exact problem, we might help.
这篇关于如何使用此问题创建此查询？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
