Oracle 12c: SQL Chapter Two Textbook Assignment Q1 Create a report showing ALL data from the PUBLISHER table. Q2 List contact names and phone numbers of publisher contacts from the PUBLISHER table. Show column heading for the publisher contacts as "Contact name" in the report. Q3 Create a mailing list for the customers, include both first and last names. The report should have the following headings: Name. Street Address, City, State, Zip Code

Topic: Databse Prompt: Transform as necessary and then write the XML elements to the appropriate tables in the database.Build SQL chunks for the following queries: What are the titles and prices of all books written by "Galos, Mike"? List the titles and the prices. What is the most recent year of publication of all books written by "O'Brien, Tim". What is the average price of all books in the "Fantasy" genre. Find the number of books in each genre. List the title and author of all books that cost less than the average price of books. XML Syntax: <book id="bk101">       <author>Gambardella, Matthew</author>       <title>XML Developer's Guide</title>       <genre>Computer</genre>       <price>44.95</price>       <publish_date>2000-10-01</publish_date>       <description></description>    </book>    <book id="bk102">       <author>Ralls, Kim</author>       <title>Midnight…

Using php and sql:  create a query and any supporting PHP code that will output only messages from the user named “Abla”.

PROBLEM: Create a table named BOOK_STORES to include the columns listed in the following chart. Column Name Store_ID Name Contact Rep_ID Datatype NUMBER (8) VARCHAR2(30) VARCHAR2(30) VARCHAR2(5) Constraint Comments PRIMARY KEY column Should be UNIQUE and NOT NULL : INSTRUCTIONS: Submit the complete code on doc file, run and also submit the snapshot of the result. You can paste the screen shots(2) on a MS. Word doc.

question 11 please use the picture below to answer the following question Write a SQL statement to change the value of the column Invoice_Date (new_invoice table) to today's date for Customer ID 10.

Create a new table, EMP_PROMOTION to store the employees information. You must use a subquery to create the new table. Make the salary column invisible. Display the structure of the table in SQL Developer. Also use a SELECT statement to display all records from the new table EMP_PROMOTION.

The following fields are presented in the table: Member Last Name, MemberFirstName, Street, City, State, ZipCode and MemberFee. The table contains 75,000 documents. How would you build indexes for the table and why would you create these indexes?

SQL  Table: CREATE TABLE employees (    employee_id INT PRIMARY KEY,    first_name VARCHAR(255),    last_name VARCHAR(255),    email VARCHAR(255) UNIQUE,    phone_number VARCHAR(255),    hire_date DATE,    job_id VARCHAR(255),    salary DECIMAL(10,2),    commission_pct DECIMAL(5,2),    manager_id INT,    department_id INT,    FOREIGN KEY (manager_id) REFERENCES employees(employee_id),    FOREIGN KEY (department_id) REFERENCES departments(department_id)); CREATE TABLE departments (    department_id INT PRIMARY KEY,    department_name VARCHAR(255),    manager_id INT,    FOREIGN KEY (manager_id) REFERENCES employees(employee_id));   INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id)VALUES (1, 'John', 'Doe', 'john.doe@example.com', '555-555-5555', '2022-01-01', 'IT_PROG', 8000, 0.2, 3, 10),       (2, 'Jane', 'Smith', 'jane.smith@example.com', '555-555-5556', '2022-02-01', 'IT_PROG', 9000,…

Create an SQL package specification and body called JOB_PKG, containing the following procedures: Create a procedure called ADD_JOB to insert a new job into the JOBS table. The procedure has job id, job title, minimum salary and maximum salary as parameters. Ensure that the value of maximum salary is greater than minimum salary, raise an exception if this rule is violated (create a private procedure for salary validation).

2. Write a SQL statement to insert a new user with userId ‘XXXXX’ into the users table and populate at least 5 other columns including column userName. Note: userName column is varchar(20) and its value must be unique in the table users. DO NOT insert into the “created” column but pay attention to it’s value after the insert Paste the SQL below.