Write a query to count current and discontinued products

Assignment Help PL-SQL Programming

Reference no: EM133641611

Task 1
Create a query to list the entire employees table

Task 2
Create an SQL select statement to retrieve the customer_id, company_name and contact_name of all customers based in London

Task 3
Perform the same query as in Task 1, but in the query result table, name the customer_id field to ID, company_name field to company and contact_name to contact

Task 4
Create a query to to retrieve the order_id, company_name and order_date of all orders placed before 11 July 1996

Task 5
create a query to list the product_name and quantity_per_unit of all products from the product table.
Modify this query to select only those products that are not discontinued, and in the result table, label the product_name column Product, and the quantity_per_unit column PerUnit modify the query to include the price and sort the output so we can easily find the most expensive product and the least expensive product

Task 6
Write a query to count current and discontinued products Modify this to print only the discontinued products

Task 7
Write a query to get a Product list (name, units on order , units in stock) of all current stock which has less available units than the quantity on order

Task 8
Find the Total Number of Units Ordered of Product ID 3

Task 9

construct a query to list the order id, order date, company name placing the order, the product name and the quantity ordered of all items for the orders from customer with ID CONSH

Task 10
construct an SQL statement to update employee Robert Kings title to Dr

construct an SQL statement to insert a new employee record for Frodo Baggins

Task 11

construct SQL statements to update the price of:
Perth Pasties to 45 dollars Vegie-spread to 50 dollars
Filo Mix to 8 dollars and 50 cents

Construct an SQL statement to insert an order for the customer you added to the customers table last week (with your student ID number), with the order date of 1 April 2021, the required date of 5 May 2021, a shipped date of 16 April 2021, shipped via DHL to the same shipping address as in your specific customer record and this will be created by employee Robert King.

This order should order the following 3 items with the specified quantities Perth Pasties, 20 units
Vegie-spread,10 units Filo Mix, 45 units
there is no discount for any of the products

Reference no: EM133641611

Questions Cloud

About emotional intelligence : You learned about Emotional Intelligence (EQ). Building upon the information you gained in last week's resources,

E-commerce site with mobile messaging feature : Sadie has integrated her e-commerce site with a mobile messaging feature. She is still learning about the benefits of her decision.

Define the concept of strategic information system : Define the concept of a strategic information system and provide an example. What is the use of this system in the organization?

About organizational planning : This chapter talks about organizational planning. Explain how three aspects of organizational planning

Write a query to count current and discontinued products : Write a query to count current and discontinued products Modify this to print only the discontinued products - construct an SQL statement to update employee

Why might it be an effective instructional method to use : What is the CIM? What is the idea behind the design of the CIM model? Why might it be an effective instructional method to use while tutoring?

How did some influence fashion design in fabrics : How did some influence fashion design in fabrics, like Anna Garthwaite in London? What became of these women latter in their lives?

How prenatal development influence by environmental factors : Illustrate how prenatal development is influenced by environmental AND/OR genetic factors. Utilize your Creativity, it is strongly suggested.

What is the Board called : What is the Board called? Change Advisory Board Change Configuration Board Configuration Management Board Joint Application

User Account

All Pages