Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Give me oracle sql command for the following questions - Q 1 . Write a query to display the tomorrows date in the following format:

Give me oracle sql command for the following questions -
Q1. Write a query to display the tomorrows date in the following format:September 16th of year 2022the result will depend on the day when you RUN/EXECUTE this query.Label the column Tomorrow.
Q2. For each product in category 5 that its list_price is less than $100 and greater than 85, show product ID, product name, list price, and the new list price increased by 5%. Display a new list price as a whole number (integer).In your result, add a calculated column to show the difference of old and new list prices. Name this column asPrice Difference.The query returns 5 rows.Sort the result according to product ID.
Q3. Write a query that displays the full name and job title of the manager for employees whose job title is "Finance Manager" inthe following format:Jude Rivera works as Administration Vice President.The query returns 1 row.Sort the result based on employee ID.
Q4. For employees hired in November 2016, display the employees last name, hire date and calculate the number of months between the current date and the date the employee was hired, considering that if an employee worked over half of a month, it should be counted as one month.Label the column Months Worked.The query returns 5 rows.Sort the result first based on the hire date column and then based on the employee's last name.
Q5. Display each employees last name, hire date, and the review date, which is the first Friday after five months of service. Show the result only for those hired before January 20,2016.1. Label the column REVIEW DATE.2. Format the dates to appear in the format like:3. TUESDAY, January the Thirty-First of year 20164. You can use ddspth to have the above format for the day.5. Sort first by review date and then by
last name.The query returns 6 rows.
Q6. For all warehouses, display warehouse id, warehouse name, city, and state. For warehouses with the null value for the state column, display unknown. Sort the result based on the warehouse ID.The query returns 9 rows.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions