Reference no: EM13842135
1: Display the character constant 'Greeting' with a column heading of 'Hello.'
2: Display all data from the Products table without specifying the names of the table columns. Order the results by Product Name.
3: Display all employees' names, last name first, and then first name, and hire date. Order the results by employee name, last name first, and then first name.
4: Modify query 3 so that the column headings are as follows: 'Last Name,' 'First Name,' and 'Date of Hire'.
5: Display all fields from the Sales Order detail for all products that have a unit price greater than $50. Order the results by unit price in descending order.
6: Display the Sales Order Id, Ship Date, and Freight of all orders that have a freight greater or equal to 50 and less than or equal to 1000.
7: Select the Employee's First Name, concatenated to the Last name, separated by a space. Call the column 'Employee Name,' the length of this employee name Length, the location of the first 'a' in the name 'A Location,' and the 3-5 characters from the name 'Substring.' Order the results by the Employee Name using the alias.
8: For each customer, show the number of orders placed, and the largest, smallest and total freight ordered. Only show those customers whose total freight is greater than $1000.
9: Display all product columns for products that are red and black and have a list price greater than or equal to $400 and less than or equal to $800. Use the keywords BETWEEN and IN.
10: Rewrite 9 to remove the use of BETWEEN and IN, and replace with the equivalent use of =, <, >, /= and AND and OR expressions.
|
Design a java application that will read a file containing
: Design a Java application that will read a file containing data
|
|
Create a database diagram of the final database
: Write a script to establish a foreign key constraint between EMPLOYEES and DEPARTMENTS using the common field: DepartmentID. Create a database diagram of the final database clearly depicting all tables and relationships.
|
|
Create an eight-page book report
: This assignment requires the student to read a book by one of the following personality psychologists (Freud, Erikson, Fromm, Jung, Rogers, or Skinner) and create an eight-page book report (about 2,000 words)
|
|
Describe the strategy of ford-using the strategy model
: Describe the strategy of Ford, using the strategy model in Figure 1.4: Describing Dyson's strategy, on page 20 of Foundations in Strategy, as a guide to frame the strategy description from the following two perspectives:
|
|
Display all employees names last name first
: Display all employees' names, last name first, and then first name, and hire date. Order the results by employee name, last name first, and then first name.
|
|
Collaborated to write uniform criminal code
: A group of attorneys, judges and law professionals have collaborated to write a uniform criminal code. The code would create uniformity in criminal law across the United States, defining what constitutes a misdemeanour, what constitutes a felony, how..
|
|
Bill desires rate of return on this investment
: Bill Martin made an investment several years ago, and he now has an option as to how it will take the return on that investment. Option 1 is to receive an immediate cash payment of $100,000. Option 2 is to receive a payment of $10,000 per year for th..
|
|
Report on the usefulness of birth order as a construct
: Create a 700-word report on the usefulness of birth order as a construct. You may review this week's readings, utilize the birth order resources, or other experts in this area
|
|
What documentation issued by a bank decreases the balance
: How is a business's certified check treated in doing the business's bank reconciliation? What documentation issued by a bank decreases the balance in a company's checking account balance at the bank?
|