Francisco Cruz

Use AND, OR and comparison operators in WHERE

Task 2

  • November 17, 2016 at 3:41 PM
  • Visible to public
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