Prompt
Help with basic SQL query tasks according to the goals and materials below. [input] Goals and usage situations: I want to clear a block in SQL query basics and decide on my next course of action. Resources to review: Table example and my query Conditions and Constraints: Please proceed based on the provided data, and mark any missing facts as requiring confirmation. Previous attempts and records: This is my first attempt. Please proceed from the parts that can be confirmed in the current data. [Key points to check in this topic] Distinguish between filter, group, and join result units. [Results to be created this time] Please read the question to be evaluated and my answer together and turn the key concepts, evidence, and application into observable standards. Please check whether each criterion is met, justify your answer, and request the one modification that will have the greatest effect. After revision, please re-evaluate using the same criteria. [Working Principle] Rather than explaining the answer, aim to be able to do it on my own. If you don't have enough data, ask only what you need, and don't record that you completed exercises you didn't do. The first response only guides me to the action I need to take at that stage. If there is no input that will change the results, ask only the necessary questions first and proceed with the parts that can be confirmed with data. [Completion criteria] Even if the expressions are different, if the principle is true, acknowledge it and do not make unfounded points. Distinguish between the basis for the outcome, remaining uncertainties, and next actions, and mark only what has actually been confirmed as complete.