Tasks:Select data from multiple tables Creatte a query that shows…
Question Answered step-by-step Tasks:Select data from multiple tables Creatte a query that shows… Tasks:Select data from multiple tables Creatte a query that shows employee number, first name, last name, city, phone number and postal code for all employees in France. Creatte a query that displays all payments made by customers from Canada.Sort the output by Customer Number.Only display the Customer Number, Customer Name, Payment Date and Amount.Make sure the date is displayed clearly to know what date it is. (i.e. what date is 02-04-19??? – Feb 4, 2019, April 2, 2019, April 19, 2002, ….) Creatte a query that shows all USA customers who have not made a payment. Display only the customer number and customer name sorted by customer number.Views and Joins a) Creatte a view (vwCustomerOrder) to list all orders with the following data for all customers:Customer Number, Order number, order date, product name, quantity ordered, and price for each product in every order. b) Writte a statement to view the results of the view just created. Using the vwCustomerOrder view, display the order information for customer number 124. Sort the output based on order number and then order line number. (Yes, I know orderLineNumber is not in the view) Creatte a query that displays the customer number, first name, last name, phone, and credit limits for all customers who do not have any orders. Creatte a view (vwEmployeeManager) to display all information of all employees and the name and the last name of their managers if there is any manager that the employee reports to. Include all employees, including those who do not report to anyone. Modify the employee_manager view so the view returns only employee information for employees who have a manager. Do not DROP and recreate the view – modify it. (Google is your friend). Drop both customer_order and employee_manager views. Computer Science Engineering & Technology MYSQL DBS 211 Share QuestionEmailCopy link Comments (0)
