SQL PMR

SQL PMR- 1

Ques 1 : Display the sales order details of the product named 'Cable Lock' for which the ProductId is 843.

                (Use the AdventureWorks database)

Ques 2 : Display the name, country region code, and sales year to date for the territory with Territory ID as

                 1. (Use the AdventureWorks database).

Ques 3 : Display the sales territory details of Canada, France, and Germany. (Use the AdventureWorks database)

Ques 4 : 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)

Ques 5 : Display the details of all the orders that were shipped after July 12, 2004. (Use the

                 AdventureWorks database)

Ques 6 : Display the details of all the currencies that have the word 'Dollar' in their name. (Use the

                 AdventureWorks database)

Ques 7 : Display the SalesPerson ID, the Territory ID, and the Sales Quota for those sales persons who

                have been assigned a sales quota. The data should be displayed in the following format. (Use the 

                 AdventureWorks database)

Here the question and answer of niit pmr 1, you can download easily by clicking on download button.