LeanIn-BV / LeanIn-BV/HacktoberFest2021
Query : 25
Open
Nobody has claimed this yet.
good first issue
hacktoberfest
hacktoberfest2021
question
- Dominant language
- HTML
- Stars
- 27
- Forks
- 73
- PR merge metrics
- No merged PRs in 30d
Description
⭐ Request Type
Write an SQL query to fetch duplicate records having matching data in some fields of a table.
❌ Additional Info
Read Contribute.MD for more info as to how to contribute.
Refer to the Tables in the table folder.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Read Contribute.MD first, then inspect the tables in the table folder to identify the available schemas and the expected contribution location. Confirm which fields should define a duplicate and validate the SQL query against the referenced table data; done means the query is added in the repository's expected format and returns matching duplicate records.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100