Sharon Dow

Use AND, OR and comparison operators in WHERE

And OR Whare It all passed!

  • October 24, 2018 at 1:16 PM
  • Visible to public
SELECT * FROM teacher WHERE                 salary > 70000                 AND     (teach_id > 12     OR     salary>100000)   SELECT * FROM student WHERE                 dob < '2000-02-02'                            AND     (student_name like 'J%'     OR     creditsearned >20) 

https://parkland1-my.sharepoint.com/:w:/r/personal/sdow3_stu_parkland_edu/_layouts/15/Doc.aspx?sourcedoc=%7B49198A6F-18AB-40C0-BF1C-94B3CD5DF86B%7D&file=Module%202_%20CSC176%20Data%20Systems_Sharon%20Dow%20102318.docx&action=default&mobileredirect=true