Question: MySQL Query 2. Write a SELECT statement that returns these column names and data from the order_instruments table: item_id The item_id column item_price The itemprice

MySQL

Query

2. Write a SELECT statement that returns these column names and data from the order_instruments table: item_id The item_id column item_price The itemprice column discount amount The discount_amount column quantity The quantity column price_total A column that's calculated by multiplying the item price by the quantity discount_total A column that's calculated by multiplying the discount amount by the quantity item_total A column that's calculated by subtracting the discount amount from the item price and then multiplying by the quantity Only retum rows where the item_total is greater than 500. Sort the result set by the item_total column in descending sequence. item id price total Table 1 Quantity 2 discount total item_price 1199.00 item_total discount amount 359.70 1308.84 5 2398.00 719.40 1678.60 3 2517.00 1 2517.00 1308.84 359.70 1 1199.00 1 1199.00 359.70 120.00 1208.16 839.30 679.99 11 1 120.00 799.99 799.99 799.99 799.99 9 240.00 1 240.00 559.99

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!

MySQL - Please provide screenshot /******************************************************** * This script creates the database named my_guitar_shop...

MySQL Assignment Your Portfolio Project consists of two parts, a lesson learned reflection report and a database design and analysis project. Part 1: Lessons Learned and Reflection Write a 2- to...

Hello, can someone help me to write a query for MySQL based on the instructions below? 1. Write a SELECT statement that returns these column names and data from the Products table: product_name The...

Database mysql: 1. Write a SELECT statement that returns these column names and data from the Products table: product_name The product_name column list_price The list_price column discount_percent...

1. Write a SELECT statement that returns these column names and data from the Order_Items table: item_id - The item_id column item_price - The item_price column discount_amount - The discount_amount...

Write a SELECT statement that returns these column names and data from the Order _ Items table: item _ id The item _ id column item _ price The item _ price column discount _ amount The discount _...

Write a SELECT statement that returns these column names and data from the Order_Items table: item_id The item_id column item_price The item_price column discount_amount The discount_amount column...

Using the My Guitar Shop database you installed in Module 1 , develop the following queries. SUBMIT A SCREENSHOT OF EACH STEP. 1 . Write a SELECT statement that returns these column names and data...

USE SIMPLE SQL Use the new database called: CreateMyGuitarShop.sql MyguitarShop database is going to be used for this part In these exercises, you'll enter and run your own SELECT statements. Write a...

SQL 1. Write a SELECT statement that returns one column from the Customers table named full_name that joins the last_name and first_name columns. Format this column with the last name, a comma, a...

How can the average person Impact Healthcare delivery?

If bromine atom is available in the form of say, two isotopes 79 35 Br (49.7%) and 81 35 Br (50.3%), calculate the average atomic mass of bromine atom.

What is the argument for regulation and deregulation in an economic activity?

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...

6. Evaluate and explain the following statements: LO2 a. The market system is a profit-and-loss system. b. Competition is the disciplinarian of the market economy.

9. Some large hardware stores such as Home Depot boast of carrying as many as 20,000 different products in each store. What motivated the producers of those individual products to make them and offer...

4. What are the advantages of using capital in the production process? What is meant by the term division of labor? What are the advantages of specialization in the use of human and material...