SQL入门求助：如何获取查询中的额外返回结果？

Hey there! Let's work through this together—totally get how hands-on SQL problems can throw you for a loop even after learning the basics. Since you're only getting the result 122 right now and need two more, here's what we need to figure out first:

• Share your actual SQL query: The exact code you ran to get 122 is key. For example, did you use a LIMIT clause that's restricting results? Or a WHERE condition that's too narrow?
• Describe your table structure: What columns are in the table you're querying? What type of data do they hold (e.g., integers, strings, dates)?
• Define the expected extra results: What do those two additional entries look like? Are they specific values, or do they fit a certain condition (like rows from a different date range or category)?

To give you a quick example of a common issue: If your first query looked like this:

SELECT total FROM sales WHERE region = 'North' LIMIT 1;

You'd only get one result because of LIMIT 1. Removing that clause or adjusting the WHERE condition to include more regions (like WHERE region IN ('North', 'East', 'West')) would return more matching rows.

Once you share those details, we can zero in on exactly how to adjust your query to get those two extra results you're after!

内容的提问来源于stack exchange，提问作者test Account