LeanIn-BV / LeanIn-BV/HacktoberFest2021
Query: 8
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 that fetches the unique values of DEPARTMENT from the Worker table and prints its length.
❌ 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 and inspect the tables in the table folder to confirm the Worker schema. Write a query that returns unique DEPARTMENT values from Worker and prints their length; done means the query matches the requested output.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 1/5
- Estimated time
- Under an hour
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100