Use AND, OR and comparison operators in WHERE

SELECT `Salary(Millions)` from Soccer_Players WHERE `Salary(Millions)` > 3 and `Salary(Millions)` < 10

SELECT `Net Worth(Millions)`, name from Soccer_Players WHERE `Net Worth(Millions)` > 100 and `Net Worth(Millions)` < 400

SELECT name, age from Soccer_Players WHERE `Age` > 25 and age < 30

SELECT name, age,`Net Worth(Millions)` from Soccer_Players WHERE `Age` < 27 and `Net Worth(Millions)` > 30 or `Net Worth(Millions)` < 35

/* query 1 */
SELECT
    articles.title,
    upper(articles.body) as content,
    articles.article_id,    
    COUNT(ReplyJoin.comment_id) as replies_count
FROM 
    articles
LEFT OUTER JOIN 
    comments AS ReplyJoin
ON 
    ReplyJoin.article_id = articles.article_id
WHERE 
    (articles.body like '%SWEET%' and articles.user_id < 4) or articles.title like '%blandit%' /* <- EVIDENCE HERE */
GROUP BY 
    articles.article_id
HAVING 
    COUNT(ReplyJoin.comment_id) > 1
ORDER BY 
    articles.title
;

/* query 2 */
SELECT
    lower(articles.title) as lower_title,   
    GROUP_CONCAT(comments.body SEPARATOR ' + ') AS comment_summary,
    articles.article_id
FROM 
    articles
LEFT OUTER JOIN 
    comments
ON 
    comments.article_id = articles.article_id
WHERE
    articles.article_id < 5 and LENGTH(articles.body) > 50 and comments.parent_id is not NULL /* <- EVIDENCE HERE */
GROUP BY 
    articles.article_id
HAVING
    NOT comment_summary like '%bart%'
ORDER BY
    LENGTH(articles.body) ASC
;

/* query 3 */
SELECT
  users.name,
  comments.body as 'content',
  HEX(SUBSTRING_INDEX(comments.body, ' ', -1)) as 'secret',
  COUNT(users.name) as 'stack'
FROM
  comments
LEFT OUTER JOIN 
  users
ON 
  users.user_id = comments.user_id
LEFT OUTER JOIN 
  comments as parent_comment
ON 
  comments.parent_id = parent_comment.comment_id
WHERE
  ((comments.parent_id % 2) = 0 and users.name != 'jables') or comments.parent_id = 5 /* <- EVIDENCE HERE */
GROUP BY
  secret
HAVING
  secret != HEX('billy') and stack = 2
ORDER BY
  secret DESC, users.name ASC
;


/* query 4 */
SELECT MIN(LENGTH(name)) 
FROM users 
WHERE name != 'Billyjim Cricketwhisker' and (user_id % 2 = 1 or name like '%o%'); /* <- EVIDENCE HERE */