Reference no: EM13781400
1. Write a query to display the products that have a price greater than $ 50.
2. Write a query to display the current salary for each employee in department 300. Assume that only current employees are kept in the system, and therefore the most current salary for each employee is the entry in the salary history with a NULL end date. Sort the output in descending order by salary amount.
3. Write a query to display the starting salary for each employee. The starting salary would be the entry in the salary history with the oldest salary start date for each employee. Sort the output by employee number.
4. Write a query to display the invoice number, line numbers, product SKUs, product descriptions, and brand ID for sales of sealer and top coat products of the same brand on the same invoice.
5. The Binder Prime Company wants to recognize the employee who sold the most of their products during a specified period. Write a query to display the employee number, employee first name, employee last name, email address, and total units sold for the employee who sold the most Binder Prime brand products between November 1, 2013, and December 5, 2013. If there is a tie for most units sold, sort the output by employee last name.
6. Write a query to display the customer code, first name, and last name of all customers who have had at least one invoice completed by employee 83649 and at least one invoice completed by employee 83677. Sort the output by customer last name and then first name.
7. LargeCo is planning a new promotion in Alabama ( AL) and wants to know about the largest purchases made by customers in that state. Write a query to display the customer code, customer first name, last name, full address, invoice date, and invoice total of the largest purchase made by each customer in Alabama. Be certain to include any customers in Alabama who have never made a purchase; their invoice dates should be NULL and the invoice totals should display as 0.
|
Complaints of subordinates regarding delegation
: Discuss why one of the major complaints of subordinates regarding delegation is the issue of dumping. Offer an example of a personal experience or observation of dumping taking place.
|
|
Create a form to register a user to an online store
: Create a form to register a user to an online store. User must create a username and password. These are required and the password must not be shown in clear text. Password should include a way to confirm password.
|
|
Write a program that reads an infix or postfix expression
: Write a program that reads an infix or postfix expression from an input file, evaluates the expression and outputs the result.
|
|
Java program that prompts for the gpa
: This assignment will give you practice with interactive programs, if/else statements and methods that return values. Your program will prompt the user for information about two applicants and compute an overall score for each applicant. This is ..
|
|
Write a query to display the starting salary
: Write a query to display the starting salary for each employee. The starting salary would be the entry in the salary history with the oldest salary start date for each employee. Sort the output by employee number.
|
|
Draw the data flow diagrams level 0
: draw the Data Flow Diagrams Level 0 and Level 1 using Microsoft Visio. A visitor may get Registration after filling "Sign Up" form.
|
|
Write an application that uses a one dimensional array
: Write an application that uses a one dimensional array: the user enters 5 numbers, each of which is between 10 and 100. As each number in input, display it only if it is not a duplicate of previous numbers entered.
|
|
Write a function that accepts an integer parameter
: Write a function that accepts an integer parameter and returns its integer square root. The function should throw an exception if it is passed an integer that is not a perfect square. Demonstrate the function with a suitable driver program
|
|
Write a program to compute the cumulative gpa
: This program will compute the cumulative GPA based on user input. This program will use dialog boxes with the JOptionPane class as well as the console to send/receive information to/from the user.
|