View the step-by-step solution to:

Question


I need an sql commands for these questions:


1.    For all employees in France,

display employee number, first name, last name, city, phone number and postal code.  


2.    Create view (customer_order) to  list all orders with the following data for all customers:  

Order number, order date, product name, quantity ordered, and price for each product in every order


3.    Using the customer_order view, display the order information for customer number 124. Sort the output based on order number and then order line number.


4.    Display customer number, first name, last name, phone, and credit limits for all customers who do not have any orders


5.   Create view (employee_manager) 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


6.    Modify the employee_manager view so the view returns only employee information for employees who have a manager


7.    Drop both customer_order and employee_manager views

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Let our 24/7 MYSQL tutors help you get unstuck! Ask your first question.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors