UPDATE order_details SET quantity = quantity --10 What happens if we run this command in MySQL? a.) An error is thrown due to the --. b.) The quantity in the order_details table for all records is decremented by 10. c.) The order_details table has all of the quantity set to the same value as it previously had. d.) The quantity in the order_details table for all records is incremented by 10.

The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the database. However, the team wants to calculate the VAT after the discounts are applied on the prices. In addition, it is important to remember if there is no discount/offers, then the value is NULL in the TRAVELS table. Create a procedure called VATCalculator to calculate the VAT amount and return with the corresponding travel ID. In addition, execute the procedure to account for NULL values and send the respective result to the team. The VAT value should be rounded to 2 decimals.

I would like to create a function to sum up total order amount within the date range, but i don't know how to write the right query. The query below is for counting the total orders, but I want to change to sum up total order amount. The Database table is attached. Please assist. ************************************** USE SQLBook; DROP FUNCTION IF EXISTS GetDateRangewithordersAmountGO CREATE FUNCTION GetDateRangewithordersAmount(       @startDate DateTime,    @endDate DateTime)RETURNS TABLE ASRETURN (    select [State], count (*) as [TotalOrderAmount]   FROM [SQLBook].[dbo].[Orders]   WHERE [OrderDate] between @startDate AND @endDate   group by [State])GO SELECT * FROM GetDateRangewithordersAmount('2015-09-01','2015-10-31');GO

!I am doing all this from cengage! Task 10: List all the tables contained within the system catalog, but only display the first 10 records with a TABLE_TYPE of SYSTEM VIEW. I did with:  SELECT * FROM (SELECT * from KimTay) WHERE ROWNUM <= 11;  and with: SELECT * FROM (SELECT TABLE_NAME FROM ALL_TABLES ORDER BY TABLE_NAME ) WHERE ROWNUM <= 10;   and with: SELECT * FROM SYSTABLES   but nothing worked and some of them gave me an error as (ERROR 1248 (42000) at line 1: Every derived table must have its own alias) and I need answers for these too: Task 11: List all the columns contained within the system catalog, but only display the first 11 records that are in the KimTay TABLE_SCHEMA. Task 12: List all the views contained within the system catalog, but only display the first 12 records. Task 13: Write the command to display only tables within the system catalog that have the KimTay TABLE_SCHEMA and are of the type BASE TABLE. Display only the following columns:…

a. Write the SQL commands to create each table after normalization.b. Write insert command to add 5 rows in each of the table.c. Write a delete command to delete row from each table.d. Write the commands to query following values.1. Show Product id and finish date for all Products2. Show Product id and finish for all Products, sort by Product_Line_ID byascending order3. Show Product id and finish for all Products, sort by Product_Line_ID bydescending order4. Show each Product_Line_ID and the total number of Products for theProduct_Line_ID

First, create (Clone) another version of DEPARTMENTS table with Create table as select command .something like this below. CREATE TABLE new_departments AS SELECT * FROM hr_DEPARTMENTS WHERE 1=2;  This unmatcheched WHERE condition will be able to create same table as DEPARTMENT but no data in it. Empty version. Create a PL/SQL block that selects the record which belongs to maximum department ID in the hr_departments table and stores entire record info to composite variable as RECORD. (Lets say cv_dept) Create this composite variable same ROWTYPE of DEPARTMENT table. Declare a variable, v_max_deptno , of type NUMBER in the declarative section. Start the executable section with the BEGIN keyword and include a SELECT statement to retrevive the maximum department_id from the departments table. By using this v_max_deptno use this number in WHERE condition of SELECT statement and make sure you only bring one row from DEPARTMENTS table to composite variable. You will now INSERT this max…

Insert the following records into their corresponding tables, using the MySQL CLI. Take a screenshot of a Select * command being successfully executed on each table (6 total).  Subject   subjectNumber Name gradeLevel 62 Algebra 9 33 Biology 10 83 Legal Studies 11 35 Entomology 9 70 Norse Mythology 10 23 Geography 10 67 Literature 12 78 World History 11 13 US History 12 9 Astronomy 9 53 Self Defense 12 85 Introduction to Computer Science 11 43 Algebra II 10

Here we have  Creating table code according to syntax in Oracle APEX.         CREATE TABLE DEPT ( DEPTNO NUMBER(10) NOT NULL, DNAME VARCHAR2(50) NOT NULL, LOC VARCHAR2(50) , CONSTRAINT DEPT_PK PRIMARY KEY (DEPTNO) );       Step 2: Emp table CREATE TABLE EMP( EMPNO NUMBER(10) NOT NULL, ENAME  VARCHAR2(50) NOT NULL, JOB  VARCHAR2(50) , MGR  VARCHAR2(50) , HIREDATE  DATE,  SAL  NUMBER(5) ,  COMM  VARCHAR2(50) ,  DEPTNO  NUMBER(10) NOT NULL, CONSTRAINT EMP_PK PRIMARY KEY (EMPNO), CONSTRAINT EMP_FK  FOREIGN KEY ( DEPTNO ) REFERENCES DEPT  (DEPTNO ) );       Step 3 CREATE TABLE SALGRADE  ( GRADE NUMBER(10) NOT NULL,  LOSAL NUMBER(10) ,   HISAL NUMBER(10) , CONSTRAINT SALGRADE_PK PRIMARY KEY (GRADE) ); Question: Give all employees records who have salaries in between 1000 and 2000 (both included)Get all employee names whose name the second letter is ‘A’.Retrieve all employees records who don’t take a commission.Get all employee's records who work as ‘CLERK’.