User Account

All Pages

Formulate a single sql query to produce

Assignment Help PL-SQL Programming
Reference no: EM133414674

Question: For each information request below, formulate a single SQL query to produce the required information. In each case, you should display only the columns requested. Be sure that your queries do not produce duplicate records unless otherwise directed

1. Give date and the sum of tax and shipping for each sale from December 20th through December 25th of 2015. (use BETWEEN. Name the calculated column SUM)

NOTE: Due to an anomoly within MySQL for numeric fields, sometimes calculated results have 14 decimal places and inexact amounts. To ensure your answer is correct use the ROUND function to two decimal places, i.e. ROUND(Tax+Shipping,

2. List the data in the Salaried Employees table about Salaried Employees earning between $40000 and $50000. (use between)

3. Give Customer IDs and cities for customers who are located in Chicago, Saint Louis, Baltimore, or Newark. (Use the IN operator.)

4. What is the customerID for Sam Gill?

5. Give the sales data for sales where sales tax was charged and total of tax and shipping is less than $15. (use the NOT operation.) Show all sales data.

6. Create an alphabetical list of names (first and last, alphabetized by last) of customers in Minnesota.

7. Give names of manufacturers and their cities that are located in cities with names ending with 'City'.

8. List the information of each sale item where 2 or more items were sold but only for sizes 5, 6, and 7 (Use the keyword IN.) Show all sale item information.

9. Give all the data for sales from January 21 of 2015 through the end of the month. (Use BETWEEN)

10. What is the first and last name of customer 610?

11. List Employee names (first and last) of employees who manage themselves or have a null value as the manager id.

12. Give full names of customers that have a 'D' as the third character in their last names. Make your query case insensitive. Eliminate duplicates.

13. What is the full name and phone number of employee 170?

14. What are the sales dates and shipping amount of sales with over $55 of shipping charges?

15. Give names of manufacturers and their cities that are located in cities with names starting with 'C'.

Reference no: EM133414674

Questions Cloud

Domestic terrorism generally applies when terroristic acts : Domestic terrorism generally applies when terroristic acts are committed overseas against United States persons or property.
Discuss at least two network management concepts : Network Management Megatrends 2014, discuss at least two network management concepts you learned from the paper
Define each protocol and describe at least two transmission : Define each protocol and describe at least two data transmission technologies associated with the protocol. Include the bandwidth limitations of each technology
Documentary-Did the Birth of a Nation film lead to new era : Documentary-Did Birth of a Nation film lead to new era (the nations response) of terrorism against African Americans that still may impact certain data today?
Formulate a single sql query to produce : Formulate a single SQL query to produce the required information. In each case, you should display only the columns requested. Be sure that your queries
Forced to give miranda warnings : What is the legal requirement for an officer to be FORCED to give Miranda warnings?
Critically reflecting on overall internship : Critically reflecting on my overall internship, referring to each of learning outcomes, and including a summative reflection
Facial recognition software and cell phone tracking device : What limits should be placed on use of electronic surveillance in the form of license plate readers, facial recognition software and cell phone tracking device?
Identifying three key work trait differences : identifying three key work trait differences you and placed that could impact your organization's culture and the impact of such differences on succession

Reviews

Write a Review

PL-SQL Programming Questions & Answers

  Write a perl subroutine for temperature conversion

Write a perl subroutine for temperature conversion named ' convert_temp '. It should be able to handle both Fahrenheit to Celsius conversions as well as Celsius to Fahrenheit conversions.

  Perform the tasks below by using the correct sql statements

Create a view so that supplier 'ASP' can only see his information from the l_foods table.  Call this view_l_foods_ASP.  Show columns supplier_id, product_code, menu_item, description, and price in your view.

  Write an sql statement to prepare a list with salesman name

Write an SQL statement to prepare a list with salesman name, customer name and their cities for the salesmen and customer who belongs to same city - What types of constraints would you expect to check?

  Write sql statements to implement return player annas grade

Write SQL statements to implement Return Player Anna's grade and rating. Return names of all elementary school players with rating over 1000.

  Querries related to sql programming

Create a parameter query based on the Customer tablethat prompts for customers in a specific state. Do not just make a select query. A parameter is different. Display the CustomerNum, CustomerName, City, and State fields.

  Pl-sql block to display last name and salary

Write a PL/SQL block that displays the last name and salary of the following people. Each of these can be done separately as PL/SQL, first to test and get the output lines then encapsulated.

  Create a problem definition for williwonk

Create a problem definition for Williwonk's, as described in Problem 1. Estimate the weights of importance. Include at least one requirement and one constraint.

  Assess emerging cyber security approaches

Write an 18 page (or longer) paper in which you identify and assess emerging cyber security approaches and technologies as well as discuss government efforts to nurture the development of these emerging technologies.

  Find the names and addresses of employees

Retrieve the names of employees in department 5 who work more than 10 hours per week on the 'ProductX' project and List the names of employees who have a dependent with the same first name as themselves.

  Write the sql select statement to display the average rent

Write the SQL SELECT statement to display the average rent of the properties. Write the SQL SELECT statement to display the property type, rooms, and rent sorted by the Type.

  Perform the subsequent queries on the array

Use LINQ to select the PartDescription and Quantity and sort the results by Quantity - Use LINQ to select from each Invoice the PartDescription and the value of the Invoice.

  Handling exceptions with undefined errors

If a shopper enters a quantity value greater than 20 for an item, Brewbean's wants to display the message "Check Quantity" onscreen -  Add code to this block to trap the check constraint violation and display the message.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd