Unit 1 Assignment B
For each assignment you will login to Oracle Apex and write your queries. The query you write will be on the top half of the screen and the results will be shown on the bottom after you click the “Run” button.
Upload a single MS Word Document with the queries that answer the problems listed below.
1. Determine which categories are represented in the current book inventory. List each category only once.
2. List the customer number from the ORDERS table for each customer who has placed an order with the bookstore. List each customer number only once.
3. Create a list of each book title stored in the BOOKS table and the category in which each book belongs. Reverse the sequence of the columns so that the category of each book is listed first.
4. Create a list of authors that displays the last name followed by the first name for each author. The last names and first names should be separated by a comma and a blank space.
5. Apply Business Analysis – Write a few sentences/paragraph for each query on how this report could be used by a manager to make a business or strategy decision
Unit 2 Assignment A
For each assignment you will login to Oracle Apex and write your queries. The query you write will be on the top half of the screen and the results will be shown on the bottom after you click the “Run” button.
Upload a single MS Word Document with all of your queries included.
1. Which customers live in New Jersey? List each customers last name, first name, and state.
2. Which books arent in the Fitness category? List each book title and category.
3. Apply Business Analysis – Write a few sentences/paragraph for each query on how this report could be used by a manager to make a business or strategy decision
Unit 2 Assignment B
For each assignment you will login to Oracle Apex and write your queries. The query you write will be on the top half of the screen and the results will be shown on the bottom after you click the “Run” button.
Upload a single MS Word Document with the queries that answer the problems listed below.
1. List all authors whose last name contains the letter pattern IN. Put the results in order of last name, then first name. List each authors last name and first name.
2. List all customers who were referred to the bookstore by another customer. List each customers last name and the number of the customer who made the referral.
3. Apply Business Analysis – Write a few sentences/paragraph for each query on how this report could be used by a manager to make a business or strategy decision