Query assignment:

Using the student and payroll databases that you created, I want you to do the following queries. Tell me the problem you are trying to solve and before doing the query write it out in pseudocode or draw a logic flowchart following the examples in my PowerPoint presentation.

1. Write a query to test for two things in an AND relationship

2. Write a query to test for two things in an OR relationship.

3. Write a query where condition A has to be true AND EITHER condition B OR condition C has to be true.

4. Write a query to where EITHER condition A and condition B are true OR just condition C is true.

5. Write a query in SQL to test for two things in an AND relationship (different than #1).

6. Write a query in SQL to test for two things in an OR relationship (different than #2).

7. Write a query in SQL where condition A has to be true AND EITHER condition B OR condition C has to be true.

8. Write a query in SQL where EITHER condition A and condition B are true OR just condition C is true.