Database: Oracle AI Database 26ai. Write your answer using the table and column names supplied below.
Objective: Calculate four summary values over a filtered set of rows.
Assume MyTable has Sales NUMBER and State VARCHAR2(2). Use these sample rows:
How to submit: Enter your SQL and reasoning, then select Submit to compare with the model solution. This is a self-assessment: the website does not connect to a database or execute your SQL.