Access and SQL

Access and SQL

This assignment will be started in class and finished for homework. You should be using the books09 database that we used in previous weeks. There are some newly added SQL queries, so you will need to download the database again. Use the queries with SQL in the name.

Question #1: Either find an SQL query that matches this logic and copy and paste the SQL into the answers or write the SQL that will accomplish this logic and paste it into this document. If you write, be sure to test!

Question #2: Either find an SQL query that matches this logic and copy and paste the SQL into the answers or write the SQL that will accomplish this logic and paste it into this document. If you write, be sure to test!

Question #3: Either find an SQL query that matches this logic and copy and paste the SQL into the answers or write the SQL that will accomplish this logic and paste it into this document. If you write, be sure to test!

Question #4: Either find an SQL query that matches this logic and copy and paste the SQL into the answers or write the SQL that will accomplish this logic and paste it into this document. If you write, be sure to test!

Question #5: Either find an SQL query that matches this logic and copy and paste the SQL into the answers or write the SQL that will accomplish this logic and paste it into this document. If you write, be sure to test!

Question #6: Either find an SQL query that matches this logic and copy and paste the SQL into the answers or write the SQL that will accomplish this logic and paste it into this document. If you write, be sure to test!

Question #7: Which SQL query tests to see if condition A is true and also that either condition B or condition C are true?

Question #8: Which SQL query tests to see if a group of two conditions has both conditions true or a stand alone condition is true?

Question #9: Write the SQL query in Access to test for Course Technology as the publisher and either topic of CSS or price < 75. Test it and copy and paste the solution into the answer sheet.

Question #10: Write the SQL query in Access to test for Course Technology as the publisher and year published greater than 2005 or price < 25.