Good Evening,

I have an SQL language assignment that needs queries created.  I have attached the information here.

1.Create a query to display the country name and region id of the countries with a region_idgreater than 2.2.Create a query to display the country name and region id of the countries for one speciFccountry.3.Write a query to display your name, and the current date on a single line of output.4.Display using the job_history table the EMPLOYEE_ID, JOB_ID, START_DATE, and END_DATE, ofevery employee who was terminated a±er 1997.5.Write a query using the employees table to determine what salaries would be if the employeeswere given a 15% raise. Label the column New Salary. Display four columns from the employees tableincluding the salary column.6.²or each Employee in the job_history table display the employee_id, job_id, department_id andcalculate the number of months between the start_date and the end_date. Label the column MONTHSBETWEEN. Round the number of months up to the closest whole number.7.Write a query using the jobs table that produces the following output concatenated. , has aminimum salary of, , but a maximum salary that is more than the min_salary. Provide a column alias foreach column.8.Write a query using the countries table to display the STREET_ADDRESS with the Frst le³ercapitalized and all other le³ers lowercase and the length of the CITY.9.Write a query using the countries table to display the country id, and country name for threespeciFc regions without using the ‘or’ operator.10.Write a query using the countries table to display the country id, and country name for threespeciFc regions whose country_name ends with an s.11.Write a query using the departments table that displays the department number, departmentname, manager id and loca´on id where the manager id or loca´on id is null.12.Create a query that will display the department number, department name and loca´on id. If thedepartment does not have a loca´on id put “No Loca´on is Listed”. Create an alias for the column.13.Write a query using the job_history table to display the employee id, start date, and end date forall employees with an end date of 15 March 1997.14.Display the highest, sum, and average actual salary of all employees in the employees table.Label the columns Maximum, Sum and Average “Actual Salary”, respec´vely. Round your results to thenearest whole number.15.Write a query to display the number of job id’s with the same salary.16.Write a query that will display the diµerence between the highest and lowest start_date in thejob_history table. Label the column “Highest and Lowest”.17.Write a query using the jobs and job_history tables to display the job id , department id, and job´tle for all employees.

• 1495690690-aak.CIS 276 Week 5 Assignment 5.docx
• 1495690691-aak.CIS 276 Week 5 Table Information.docx

ComputerScienceExpert

(11)

Status NEW Posted 25 May 2017 05:05 AM My Price 9.00

-----------

Attachments

file 1495690692-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer