Question about practice problem 8 SQL 3.3

Questions ArchiveCategory: DatabaseQuestion about practice problem 8 SQL 3.3
Calvin Schofield asked 2 years ago

Anyone know why this slight change causes such a different result? This is for practice problem #8 of 3.3 SQL Statements This is what I put: SELECT lastname, salary, positiontitle, locationcity FROM employee INNER JOIN location ON employee.locationid = location.locationid INNER JOIN position ON employee.positionid = position.positionid WHERE positiontitle LIKE \’%Manager\’ AND salary > 50000 AND (locationcity = \’Miamai\’ OR locationcity = \’Chicago\’)     This is the correct answer: SELECT lastname, salary, positiontitle, locationcity FROM employee INNER JOIN location ON employee.locationid = location.locationid INNER JOIN position ON employee.positionid = position.positionid — WHERE positiontitle LIKE \’%Manager\’ AND salary > 50000 AND (locationcity = \’Miamai\’ OR locationcity = \’Chicago\’) WHERE positiontitle LIKE \’%Manager\’ AND salary > 50000 AND (locationcity = \’Chicago\’ OR locationcity = \’Miami\’)   I could really use the help understanding how this works!

1 Answers
Calvin Schofield answered 2 years ago

never mind I caught what I did. I spelled Miami wrong

Your Answer

5 + 8 =

css.php