Reference no: EM133637786

Task 1: Using Northwind Database, write SQL statements for the following data retrieval operations. NoteYou may need to refer to the schema for the exact field names while framing the queries to the following questionsWhile framing the question, the words code'numberor IDmay have been synonymously usedFor instanceCustomer Numberwhen used may refer to a field called CustomerIDSimilarlywherever the word name' is used, appropriate interpretation may be needed based on the schema - for instance if customer nameis required to be printedyou may need to retrieve CompanyName field from the Customers Tablelikewisewhen employee nameis required without any further qualificationyou may retrieve the lastname field of Employees table Exercise 7.1 Retrieve the IDs and company names of all customers that have made more than 10 orders. 7.2 Retrieve all details of Orders administered by persons who hold the designation Sales Representative and shipped by United Package. 7.3 Select the IDs and contact names of customers that have more orders than customer 'BONAP 7.4 Retrieve the names of all employeeFor each employee list the name of his/her manager in adjacent columns. 7.5 Find out all the orders placed by all the customers 7.6 Find out all the Orders processed by each Employee 7.7 Display all customers details who have placed orders and who have not placed orders) and orders details which are placed by customers. 7.8 Find out all the customers and their orders and filter the result on customer's city (London) 7.9 Display all customers details who have placed orders) and orders details which are placed by customers solve this with photographs