ITCO331 Lab 2 with each query screenshot – Guaranteed 100% Score

Lab Price = $9
Please feel free to send us your queries at: support@iqrajavaid.com
Note: In case if your problem statement is updated, please donot hesitate us and send it to us at support@iqrajavaid.com. We would surely like to help you in this regard.
Problem Statement

ITCO331 Unit 2 IP

10 SQL Statements
Details:

Using the Northwind database, write a SQL SELECT statement that will retrieve the data for the following questions:

Display the character constant ‘Greeting’ with a column heading of ‘Hello.’
1 row returned.
Display all data from the categories tables without specifying the names of the table columns. Order the results by CategoryName.
8 rows returned.
Display all employees’ names, last name first, and then first name, hire date and home phone number. Order the results by employee name, last name first, and then first name.
9 rows returned.
Modify query 3 so that the column headings are as follows: ‘Last Name,’ ‘First Name,’ ‘Date of Hire,’ and ‘Home Phone Number.’
9 rows returned.
Display the product name and quantity per unit, units in stock, and unit price for all products that have a unit price greater than $50. Order the results by unit price in descending order.
7 rows returned
Display the Name of all U.S.-based suppliers. Order the results by Name in ascending order.
4 rows returned.
Display the Order Id, ShipName, Order Date, and Freight of all orders that have a freight >/= 50 and 13 rows returned.
Rewrite query 7 to remove the use of BETWEEN and IN, and replace with the equivalent use of =, <, >, /= and AND and OR expressions.
13 rows returned.
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 5–9 characters from the name ‘Substring.’ Order the results by the Employee Name using the alias.
9 rows returned.
For each customer, show the number of orders placed, and the largest, smallest and total freight ordered. Only show those customers who have placed more than 15 orders.
9 rows returned.

Relevant Material
Screenshots

Screenshot_Query9

Screenshot_Query10

Instructions
* Please click on “Buy Now” button to complete the purchase.Please note that the payment is done through PayPal.
* If you have any issues with the payment method, please let us know at support@iqrajavaid.com and that can be discussed and considered.
* Your paypal has to be pre-loaded in order to complete the purchase or otherwise please discuss it with us at support@iqrajavaid.com.
* As soon as the payment is received through PayPal, download link of the solution will automatically be sent to the address used in Paypal.
* Please check your junk mails as the download link email might go there.
* All the contents are compressed in one zip folder.
* In case if you get stuck at any point during the payment process, please immediately contact us at support@iqrajavaid.com and we will fix it with you.
* We try our best to reach back to you on immediate basis. However, please expect to get a response within 8 hours from our side.
* Comments/Feedbacks are truely welcomed and there might be some incentives for you for the next lab/quiz/assignment.
* In case of any query, please donot hesitate to contact us at support@iqrajavaid.com.

******************************************** Good Luck ***************************************************

Privacy Policy
We take your privacy seriously and will take all measures to protect your personal information.
Any personal information received will only be used to fill your order. We will not sell or redistribute your information to anyone.
Refund Policy
Incase you face any issues with the tutorial, please free to contact us on support@iqrajavaid.com
We will try our best to resolve the issue and if still persists we can discuss for a refund in case its required.
Payment Details
Lab Price = $9
Please feel free to send us your queries at: support@iqrajavaid.com
Note: In case if your problem statement is updated, please donot hesitate us and send it to us at support@iqrajavaid.com. We would surely like to help you in this regard.

Leave a Reply