Write a query to display the first name, last name, street, city, state, and zip code of any customer who purchased a Foresters Best brand top coat between July 15, 2013, and July 31, 2013. If a customer purchased more than one such product, display the customer’s information only once in the output. Sort the output by state, last name, and then firstname.
Answer to relevant QuestionsWrite a query to display the employee number, last name, first name, and sum of invoice totals for all employees who completed an invoice. Sort the output by employee last name and then by firstname.Using the query results in Problem 35 as your basis, write a query to generate the total number of invoices, the invoice total for all of the invoices, the smallest invoice amount, the largest invoice amount, and the average ...Write a query to display the department number, department name, department phone number, employee number, and last name of each department manager. Sort the output by departmentname.What is the difference between UNION and UNION ALL? Write the syntax for each.What Oracle function should you use to calculate the number of days between the current date and January 25, 1999?
Post your question