Question: Answer these four questions Question 1) Make a query that displays all employees whose phone number starts with 515. Display the result as a single

Answer these four questions
Question 1) Make a query that displays all employees whose phone number

Question 1) Make a query that displays all employees whose phone number starts with "515". Display the result as a single column, format the results as follows: "Steven King can be contacted at 515.123.4567" You cannot use the LIKE keyword in this query. Question 2) Make a query that tells us the difference between the average minimum salary and average maximum salary in the Jobs table. Note: You do not have to format the number to show less decimal places. Example: If the average minimum salary was 5000 and the average maximum salary is 13000, then the result to display would be 8000. Question 3) Show all location's whose postal code is exactly 5 characters long. Display the postal code and city name. When displaying the city name, remove all space characters. You must not use LIKE in this query, Question 4) Display all country names in the new format: The first 3 letters of the region name combined with the last 4 letters of the country name. Order by the new country name in alphabetical order. Example: Europe & Switzerland = Eurland

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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 Programming Questions!