RDBMS Lab@Home 2

Q.1. Display the ID, type, number, and expiry year of all the credit cards in the following format. (Use the AdventureWorks database)

Ans  https://drive.google.com/open?id=0B08RKBSts8D8UGFrMVkxQmZhMTA


Q.2.  Display the details of all the customers. (Use the AdventureWorks database)


Ans. https://drive.google.com/open?id=0B08RKBSts8D8ajlSU1B3clVicUU


Q.3.  Display all the details of the sales orders that have a cost exceeding $ 2,000. (Use the AdventureWorks database)


Ans.  https://drive.google.com/open?id=0B08RKBSts8D8SFRnUjB5eDhQMnc


Q.4.  Display the customer ID and the account number of all the customers who live in the TerritoryID 4. (Use the AdventureWorks database)


Ans.  https://drive.google.com/open?id=0B08RKBSts8D8SDg4OE8yVExRbTg


Q.5.  Display the list of all the orders placed on June 06, 2004. (Use the AdventureWorks database)


Ans   https://drive.google.com/open?id=0B08RKBSts8D8QWxGSnBZbko5ZTQ


Q. 6  Display the sales order details of the product named 'Cable Lock' for which the ProductId is 843. (Use the AdventureWorks database)

Ans   https://drive.google.com/open?id=0B08RKBSts8D8a0VkclEwRUpzc0k


Q.7.  Display the name, country region code, and sales year to date for the territory with Territory ID as 1. (Use the AdventureWorks database)


Ans  https://drive.google.com/open?id=0B08RKBSts8D8YWpnMWJLOFh1eUU


Q.8. Display a list of all the sales orders in the price range of $ 2,000 to $ 2,100. (Use the AdventureWorks database)


Ans   https://drive.google.com/open?id=0B08RKBSts8D8RngtTzlHbTd4VU0


Q.9.   Display the sales territory details of Canada, France, and Germany. (Use the AdventureWorks database)


Ans   https://drive.google.com/open?id=0B08RKBSts8D8WTVROWQxZ2M4Ymc


Q.10.   Display the details of the orders that have a tax amount of more than $ 10,000. (Use the AdventureWorks database)


Ans    https://drive.google.com/open?id=0B08RKBSts8D8akdpSDVTaDhIOGM


Q.11.  Generate a report that contains the IDs of sales persons living in the territory with TerritoryID as 2 or 4. The report is required in the following format. (Use the AdventureWorks database)

Ans. https://drive.google.com/open?id=0B08RKBSts8D8YktWTVhFQlJZcXc

Q.12.  Display the details of the Vista credit cards that are expiring in the year 2006. (Use the AdventureWorks database)

Ans.   https://drive.google.com/open?id=0B08RKBSts8D8MnFaSXdvQzcwc2c

Q.13.   Display the orders placed on July 01, 2001 that have a total cost of more than $ 10,000 in the following format. (Use the AdventureWorks database)

Ans.  https://drive.google.com/open?id=0B08RKBSts8D8XzFLaXYwaFZ0LXc

Q.14.  Display the details of all the orders that were shipped after July 12, 2004. (Use the AdventureWorks database)

Ans   https://drive.google.com/open?id=0B08RKBSts8D8SEk4QVJ6UEdsa0U

Q.15.  Display a report of all the orders in the following format. (Use the AdventureWorks database)

Ans  https://drive.google.com/open?id=0B08RKBSts8D8enhibURjZ1JQQmM

Q.16.  Display the order ID and the tax amount for the sales orders that are less than $ 2,000. The data should be displayed in ascending order. (Use the AdventureWorks database)

Ans   https://drive.google.com/open?id=0B08RKBSts8D8d1ZGNU5CeVdpMEE

Q.17.  Display the order ID and the total amount due of all the sales orders in the following format. Ensure that the order with the highest price is at the top of the list. (Use the AdventureWorks database)

Ans  https://drive.google.com/open?id=0B08RKBSts8D8T2JpRjVZZVVvbTA

Q. 18.  Display the order number and the total value of the order in ascending order of the total value. (Use the AdventureWorks database)

Ans  https://drive.google.com/open?id=0B08RKBSts8D8X19vMzIwWEJRcWs

Q.19..  Display the details of all the currencies that have the word 'Dollar' in their name. (Use the AdventureWorks database)

Ans  https://drive.google.com/open?id=0B08RKBSts8D8V0ZwYjNHSGJ1UDA