UPDATE Positions
Set Salary=Salary + Salary*10%
Where Salary <= 50000

Query design:

1) select table or tables
2) select fields
3) set criteria
4) set sorting order

SELECT Positions.Title, Positions.Description
FROM Positions
where salary>30000

SELECT Positions.Title, Positions.Description, Positions.Salary
FROM Positions
ORDER BY Positions.Salary;

there is a like operator
where
author like "G*"

like "J?sh"

usually on a test
begins with
ends with
contains

G*
*g
*g*