I very often find SQL beginners asking simple questions about standard SQL constructs. They often don't realize that it's a JOIN operation they are after, but it should be pretty obvious for anyone who have read at least a tutorial on the subject (Example 1: "i was having hart time finding it in exact format ... im new to sql and for example things like "users.id = emails.user_id" are still confusing for me") (Example 2).
The questions are often very precisely related to the askers' own schemas and they can't, or won't try to, understand general explanations of joins, but instead want exact answers which match their own schema. I have found that this makes it hard to find exact duplicates because other people may have other names in their schema and thus the other question may look very different (Example 3: Very standard problem, in my opinion, but how do I find duplicates?).
I'm leaning towards "Too localized" because questions where the asker want the answer to match their exact schema are often very localized. At the same time, the schema is often crucial for understanding the question at all so it must still be included in SQL questions. Maybe I'm just confused about the "Too localized" category?
So a short summary of my rather broad question:
- Should we close these types of questions? With what motivation?
- Can they be closed even if an exact duplicate is hard to find?
- Maybe I'm talking about two different types of problems?
- Do the experienced users have any hints on how to find duplicates?