jaywcjlove / jaywcjlove/mysql-tutorial

Count wont work

Open
#37 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
No language data
Stars
4.8k
Forks
814
PR merge metrics
No merged PRs in 30d

Description

Am trying to get another count for where the "qty_count" is > 2![image](https://user-images.githubusercontent.com/60304620/159447651-b8a83935-48b4-4ffa-8437-f522af078c51.jpeg)

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reviewing the issue screenshot and locating the query that calculates qty_count. Reproduce the reported result, determine how the count should behave when qty_count is greater than 2, and confirm the corrected query returns the expected count.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql, sql
Domain
databases
Issue type
Bug
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.