Put an asterisk next to the Category field in the BOOK_PRICING database to indicate that it is not being utilized. Check to see whether the column is still accessible after you've removed it.

Create a list of all book titles and costs. Precede each book’s cost with asterisks so that the width of the displayed Cost field is 12. (refer to the tables in the JustLee Books database.)

Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To decrease the postal costs, they will send gifts to owners in batches to their corresponding offices. Similarly, the marketing team will send the gifts in groups to the residents living in the same property. Therefore, you will need to provide them the number of gifts for each StayWell office and number of gifts for each property. The column headers for the first table should be OFFICE_NUM and GIFTS, the column headers for the second table should be PROPERTY_ID and GIFTS. Provide the StayWell team the number of gifts for each office. Provide the StayWell team the number of gifts for each residence.

The Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name and height for only horses that have an above average height. Order the results by height (ascending). Hint: Use a subquery to find the average height.

Use the data from the class assignment, ALTER TABLE and add two more columns Phone and email. Describe the table (show its structure) and drop the country column, describe the table (show structure). Now, create a new table based on the existing table person with the help of a subquery (The new table will contain the data from “person” table) and name the table person_self. Show its output (table created and its structure).     NOTE: Use the ALTER TABLE command with ADD clause Use the ALTER TABLE command with DROPCOLUMN clause Use the CREATE TABLE command with AS (SELECT SUBQUERY) clause

Task 1: 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. Create a procedure to calculate the VAT. 1   Make sure you are using the following format to change the delimiter for the procedure: DELIMITER $$-- statements --END $$DELIMITER ;   Test QueryCALL VATCalculator() Expected Results TRAVEL_ID VAT 5001 1.24 5002 1.64 5003 0.99 5004 2.12 5005 0.89 5006 1.05 5007 0.30 5008 1.51 5009 1.08 5010 1.64

In the BOOK_PRICING table, you should indicate that the Category field is not being utilized. Confirm that the column is no longer an option to choose.

Create a trigger named Products_UPDATE that checks the new value for the DiscountPercent column of the Products table. This trigger should raise an appropriate error if the discount percent is greater than 100 or less than 0. If the new discount percent is between 0 and 1, this trigger should modify the new discount percent by multiplying it by 100. That way, a discount percent of .2 becomes 20. Test this trigger with an appropriate UPDATE statement.

Modify the SELECT statement to select the title and release date of PG-13 movies that are released after February 1, 2008. Run your solution and verify the result table shows just the titles and release dates for The Dark Knight and Crazy Rich Asians.       CREATE TABLE Movie (  ID INT AUTO_INCREMENT,  Title VARCHAR(100),  Rating CHAR(5) CHECK (Rating IN ('G', 'PG', 'PG-13', 'R')),  ReleaseDate DATE,  PRIMARY KEY (ID)); INSERT INTO Movie (Title, Rating, ReleaseDate) VALUES  ('Casablanca', 'PG', '1943-01-23'),  ('Bridget Jones\'s Diary', 'PG-13', '2001-04-13'),  ('The Dark Knight', 'PG-13', '2008-07-18'),  ('Hidden Figures', 'PG', '2017-01-06'),  ('Toy Story', 'G', '1995-11-22'),  ('Rocky', 'PG', '1976-11-21'),  ('Crazy Rich Asians', 'PG-13', '2018-08-15'); -- Modify the SELECT statement:SELECT *FROM MovieWHERE ReleaseDate < '2000-01-01';

I am stuck on a question. Please assist with writing this code: Create a trigger for the EMPLOYEES table that will set the commission amount to .4 whenever the department_id is 80. Test  your trigger COMPLETELY for every event it is defined.  (Sometimes, UPDATE statements must have UPDATE tablename on a separate line by itself to keep APEX from hanging).  This should work both for new rows and existing rows that are updated.  Scenerio:  All employees who are in the sales department (80) will have their commission always set to .4. This trigger is to enforce this business rule automatically.