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

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
Get step-by-step solutions from verified subject matter experts
