Question: Answer these using SQL use customermodels and extract the following data: 1. Full name of the employees who work for the offices 1,4, and 5.

Answer these using SQL use customermodels and extract the following data: 


1. Full name of the employees who work for the offices 1,4, and 5. 


2. All data of the customers who the second highest and third highest credit limit. 


3. All data of the customers whose name starts with 'a'. 


4. Order Numbers of order that had at least one item with a total cost greater than $ 200. 


5. All data of the employees whose last name starts with 'p' and who work for the office 1. 


6. All data of the employees with E and S in any part of their name. 


7. Order Number, Order Line Number, Product Code, and Total Cost of Order Items with a unit cost between 50 and 100 and a total cost that is less than 1000, sorted by Order Number, and Order Line Number (both in ascending order). 


8. Name and phone of the customers who are in France, USA, Australia, or Norway whose Address Line 2 is Not Null.

Step by Step Solution

3.44 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

I can help you write SQL queries for these tasks However Ill need to make some assumptions about the ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!