Want to know:
SELECT author, MIN(price) AS Минимальная_цена, MAX(price) AS Максимальная_цена FROM book WHERE author <> 'Есенин С.А.' GROUP BY author HAVING SUM(amount) > 10;Лучше как можно больше использовать WHERE тк таким образом будут дальнейшие операции выполняться с меньшим объемом данных
Get a detailed, AI-powered explanation for this question and thousands more on StudyFetch.
Get the Answer for FreeHow StudyFetch Helps You Master This Topic
AI-Powered Answers
Get instant, detailed explanations powered by AI that understands your course material.
Deep Understanding
Go beyond surface-level answers with step-by-step breakdowns and examples.
Personalized Learning
Sparky adapts to your learning style and helps you connect ideas.
Practice & Test
Turn any question into flashcards, quizzes, and practice tests to solidify your knowledge.
Explore More Questions
- Is the secon complex a proton pump ?
- Which type of architecture diagram shows technical tools and resources that you need to deliver a solution?A. Reference architecture diagramB. Code architecture diagramC. Solution architecture diagramD. Resource architecture diagram
- pour trouver la raison avec 2 termes ari