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
- verbe caractérisant la symétrie orthogonale
- In the rapid application development (RAD) model, the _____ phase resembles the final tasks in the SDLC implementation phase.
- The following linear programming problem has _________________Max Z = $40x1 + $10x2Subject to: 8x1 + 5x2 ≤ 80 2x1 + 1x2 ≥ 100 x1, x2 ≥ 0