Question: I just need the SQL statements for these problems: 5. Add the following item to the NONGAME table: item number: TL92; description: Dump Truck; number

I just need the SQL statements for these problems:

I just need the SQL statements for these problems: 5. Add the

following item to the NONGAME table: item number: TL92; description: Dump Truck;

5. Add the following item to the NONGAME table: item number: TL92; description: Dump Truck; number of units on hand: 10, category: TOY; and price: 59.95. 6. Delete every item in the NONGAME table for which the category is PZL. 7. In the ME table, change the category for item FD11 to null. 8. Add a column named ON HAND VALUE to the NONGAME table. The on-hand value is a seven-digit number with two decimal places that represents the product of the number of units on hand and the price. Then set all values of ON HAND VALUE to ON HAND PRICE. 10. Remove the NONGAME table from the TAL Distributors database

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Task 1 : Create a NONCAT table with the structure shown below. Field Type Null Key Default ITEM _ ID char ( 4 ) NO PRI NULL DESCRIPTION char ( 3 0 ) YES NULL ON _ HAND int YES NULL CATEGORY char ( 3...

I just need the SQL statements for these problems: 2. Insert into the NONGAME the item number, description, number of units on hand, category, and unit price from the ITEM table for each item that is...

Use SQL Workbench. Module 6 KimTay Pet Supplies. 1. Create a NONCAT table with the structure shown in FIgure 6-28. (Picture Below) 2. Insert into the NONCAT table the item ID, Description, number of...

2. Insert into the NONGAME table the item number, description, number of units on hand, category, and unit price from the ITEM table for each item that is not in category GME. 3. In the NONGAME...

Please show in SQL code INPUT& OUTPUT (Screenshots) For each of the assigned problems, write a SQL query to retrieve the required information and test the query in MySQL Premiere Products Database:...

HEY ; THANK YOU FOR LOOKING AT MY QUESTION! I AM JUST ASKING FOR THE COMMANDS SO I CAN EXECUTE VIA MY SQL FOR MY HOMEWORK PLEASE. THE TABLES ARE AT THE BOTTOM SO THAT YOU HAVE THE RIGHT TABLE NAMES...

Assignment in attachment. Very simple assignment. Question 1 Cost of goods sold is determined only at the end of the accounting period in both a perpetual and a periodic inventory system. neither a...

rectangular channel 3.5m wide laid at a slope of 0.0036, uniform flow occurs at a depth of 2m. Find how high can a hump be raised without causing choking of flow. If the upstream depth of flow is to...

If 4 fair coins are tossed, find the probability that no more than 2 are heads. The probability that no more than 2 are heads is (Type an integer or decimal rounded to the nearest thousandth as...

Exercise 8 - 4 0 : 8 - 4 0 . Your company must obtain some laser measurement devices for the next six years and is considering leasing. You have been directed to perform an actual - dollar after -...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Suppose government spending increases. Would the effect on aggregate demand be larger if the Federal Reserve took no action in response or if the Fed were committed to maintaining a fixed interest...

Suppose that people suddenly wanted to hold more money balances. a. What would be the effect of this change on the economy if the Federal Reserve followed a rule of increasing the money supply by 3...

Suppose the federal government cuts taxes and increases spending, raising the budget deficit to 12 percent of GDP. If nominal GDP is rising 5 percent per year, are such budget deficits sustainable...