Access 2000 Database - Use the attached WEEK2_ACCESS2000.mdb database I just need the SQL code, which can be cut and pasted into a word document. 1. Perform an inner join between the BOOKS table and the ORDER_LINES table. Show the titles from the BOOK table and quantity column from the ORDER_LINES table ------------------------------------------------------------------------------------...

Queries - 1. It is time again for the company picnic. There is concern that there may be some employees who aren't age 21 yet, so COUNT how many employees we have who aren't yet age 21 as of today, and we'll decide if alcohol will be served or not. * To determine an employee's current age, you'll want to know how many years old they are (obviously) - you can do this by subtracting their b...

SN W5 HA - Write a concise summary (ideally one to two pages) of what you have learned about physical tamper-resistant devices. Yes! That's it! Given that we have covered a wide variety of topics on security applications, it's a good idea to stop for a bit, reflect on the plethora of material and summarize it. This is your chance to do so. Here are some general suggestions on how to approach t...

Database Coding - 1. Using the order_lines table from the database from lecture 2, write the SQL that will give the Min and Max values of the column "cost_each" 2. Using the week 2 homework database, show each customer number and count the instances of each customer_numb in the table orders. Hint: follow this pattern (where the words TABLE and COLUMN are filling in for real names): ...

Questions 1-7 answers provided need SQL's for each. - With the file attached please answer in SQL form the following. Thanks... 1. Which employees (by name) have degrees? (the "answer" is Smith, Johnson and Williams) SELECT at least the employee first and last names - SELECT other columns you think would be meaningful. HINT: do a JOIN between the employees and degrees table ON EMPLOYEE...