Queries

CLICK HERE TO DOWNLOAD THIS TUTORIAL INSTANTLY $15 Only

1. Write a query using the jobs table to display the job id, and job title for three specific jobs whose job description starts with an M.
2. Create a unique listing using the jobs table of all the jobs that have a minimum salary of 4000. Include the all of the columns in the output.
3. Write a query using the employees table that displays the department id, employee id, manager id and salary where the commission pct is not null.
4. Write a query using the employees table to display the employee id, hire date, and salary for all employees with a hire date of 24 March 1998.
5. Write query using the locations table that displays the street address and city of all locations based on the value of the column country id as follows:
IT Italy
JP Japan
CN Canada
UK United Kingdom
NL Netherlands
6. Write a query to display your name, and the current date on a single line of output
7. Write a query using the jobs table to determine what the max salaries would be if the marketing managers were given a 10% raise. Label the column New MKT MGR. Display three columns from the jobs table including the max_salary column.
8. Write a query using the jobs table that produces the following output concatenated:
, has a minimum salary of, , but a maximum salary that is more than the min_salary. Provide a column alias for each column.
9. Write a query using the employees table to display the employee id, last name and hire date for four specific employees without using the ‘or’ operator.